I personally love my collection (records, CD, digital) and enjoy sharing the experience with friends. I don’t use streaming unless you count soma fm at work. Sure, I’ll use YouTube to listen to some albums I don’t own, but if I truly like it I’ll buy or download it, usually on bandcamp or direct from artist if I can.
For me, I don’t believe the human brain was ever made for this level of stimulation (we shouldn’t really have 24/7 access to social media either. Go back to the “family PC” model). People have very little connection to music anymore becuase there’s too much and its too easy to access. I can barely remember all the members names in my favorite bands or all their albums. There’s little chance anyone even knows the artists of the millions of songs they’re streaming, or the story behind them.
I mainly listen to my music collection from my Plex server, but I’ll also pop in a CD on occasion and listen from start to finish. It can honestly be so refreshing to have the music experience be so physical without a screen in the way. I agree with your feelings on mainstream streaming services. You have access to a lot of music but it really discourages you from traveling deeper.