I am on a Bob Dylan run on vinyl these days and just got The Freewheelin' and other early albums of him, mainly re issues from the 1980's and they all sound spectacularly good, I get much more feeling for the music AND the lyrics when listening on vinyl (have it all on CD for decades, the early albums never got me back then).
You can spend thousands and thousands on equipment but in the end, it all depends on your ears. I know my hearing is slighly damaged at high frequencies so I am not in the right position to discuss with audiophiles as they all have perfect hearing obviously
I like all early Dire Straits vinyl recordings much more than almost all solo stuff, soundwise. To me, The The Ragpicker's Dream and Tracker have the most beautiful sound. On everything after Tracker MK's voice is sounding too loud/dull to my ears. Again all Bob albums are a totally other thing here, much much better.
My second try pressing (after the crackling noisy babyblue edition) of On Deep River sounds very good, but I stay with my opinion about MK's vocals. The Live Box I got sounds perfect, so I would suggest to give it try.
About your initial question: Streaming made me lose interest in music almost completely, hate it, and going back to vinyl more seriously last summer made me listening and loving music again so much as I did not in the last 25 years, ALTHOUGH you have to do all that turning and dust stuff. It inevitably makes you listen to it much more consciously. It is not so much the often called "vinyl experience" per se, but really a wholesome and consious thing to do. Would never miss it again.
Listening to Talk Talk, The Colour Of Spring on vinyl right now while typing this.
LE