On one hand it makes search a little more high-friction since My personal library will never be as huge as that of a streaming service. My workaround is treat Spotify like a radio and star songs I like to then download later.
In that way it’s a lot like interacting with music before streaming. It also forces me to curate a bit more.
Probably not for everyone, but I actually like it better, and I know that my library will always be there.