Regardless of pricing you can't substitute one with the other... Spotify is a streaming service with a massive library. Self hosting means you must BYO media... and, news flash, populating a library with relevant content that rivals Spotify or would satisfy your average user will almost certainly require illegally acquiring said content.
Youtube has much more music than Spotify, is better sorted by Albums (without holes, no skips) and you can easily rip it. It has all the better obscure artists, Spotify delisted.
There's also a recommendation engine via YouTube Music.
And once you start listening there, your video suggestions feed becomes a music feed thus degrade the video experience. Vids and music must be separate
This is my bottleneck too. I'm all for paying artists, and the hustle of setting up self host doesn't bother me (maybe not for my wife though, who is way less tech-y than me and is in my spotify family plan.) But the benefit of tens of millions of music, a search away, is simply too much for me to give up. I do my annually retrospective in music, and Billie Eilish was my back-to-back favorite artist of the year. Without streaming service, I probably wouldn't have tried her music at the first place.