I find it's only good at playing random songs on giant playlists, or playing the radio. Managing a library of albums is a huge pain and I still don't understand how it's supposed to work.
Then there is the problem of questionable digital masters. There's 0 transparency into the mastering process and what Spotify uses. As you've observed, some things just sound really awful on Spotify.
If you really want the best, I suggest Roon + Tidal subscription for playback. Then use Qobuz/Bandcamp/etc. to purchase lossless FLACs to import into Roon, or rip CDs yourself. This will give you the best quality, and you can be certain the source quality is good. You can use Tidal lossless for streaming things you don't buy (but the selection is much more limited). The Roon UX is way, way better than Spotify for managing a large collection of albums.