Returning to the OP, it is great that there are several flavors/choices available. I don't believe there is any one size fits all here. Physical media players, streaming, and computer server playback all serve us well. These are not either/or choices. Each has advantages, I suppose.
For me, I've put physical media players in my rear view mirror, with the lone exception being playback of Blu-Ray movies. Streaming is alright but I find it falls short for at least a couple of reasons: (1) not everything is available to be streamed from sources such as Tidal, Qobuz, etc.; and (2) streaming is not available everywhere for several reasons, and portability of my extensive library has grown to be an indispensable part of my travel and gym routine.
I do find that one place where streaming has a unique place is the discovery of new music. Years and years ago, when I regularly used Pandora and Slacker, I enjoyed that feature. But for many years now, I do and have done extensive research on a daily basis to discover new artists and new albums. In this way I learn much more about the artists and music than I would by just receiving a third party's recommendation and, as such, for me streaming service recommendations fall short. My to be listened to and experienced album list is ridiculous and I've come to accept the fact that I have an embarrassing number of albums on my server that I will never listen to in my lifetime. I may have to start a twelve step music collector's program to help me and others like me deal more constructively with our addiction.