I don’t have a recommendation but I have been looking for similar products. I am considering an esata setup to add my secondary array or a hotswap housing for switching backup drives. There are some pcie to esata adapters, you then just need power. Keeping it sata helps mitigate the risks of usb DAS connections with respect to corruption allegedly.

Emby will let you do it but you need a host server. Same with plexamp. Foobar2000 offers remote smb folder access but I don’t remember if it works as the library of it it just lets you download the files from smb.