Way back in the early 2000's, I homebrewed a simple server to stream audio from my home PC via Windows Media Services (IIRC). It featured a web app to allow me to create the playlist. It let me listen to my own music at work without having to copy files, even with the limited bandwidth of my home DSL connection.
Nowadays, I use Roon for the same purpose (specifically Roon ARC). It's not cheap, but I was already using Roon for home to easily find and manage music across my own collection and streaming services, and then play it back on many devices in my home. It takes a bit of work to get running there is a cost, so it's definitely a bit of an investment, but it generally does exactly what I want it to do and I spend my time using it rather than fighting it.
Nowadays, I use Roon for the same purpose (specifically Roon ARC). It's not cheap, but I was already using Roon for home to easily find and manage music across my own collection and streaming services, and then play it back on many devices in my home. It takes a bit of work to get running there is a cost, so it's definitely a bit of an investment, but it generally does exactly what I want it to do and I spend my time using it rather than fighting it.