I self-host on Jellyfin with Tailscale from my home server and it's been a great experience. It's fun and intentional.
I left Spotify during one of the many scandals they've had but I think this was in 2019ish based on where I was living and I just can't remember what it was. Possibly not paying the artists enough? This was pre-Rogan. Can't say their actions over the last few years have made me regret the decision.
I ran Navidrome and then Jellyfin alongside TIDAL and then Apple Music for a while, but the UX is just so much better with my own stuff and finding things to add is fun. I wish I'd spent all the money I spent on music streaming services over the past 15 years on buying music instead. Vinyl is more expensive now (I buy it anyway), but used CDs are dirt cheap and ripping them is fun.