* chatting with the owner who is supremely knowledgeable about the kinds of music I like, and buying records based on his advice
* looking for something similar to music I've found online, perhaps by the same artist or label
* looking for music I can't easily stream online, such as jazz from the ECM label. I stumbled upon one album while digging last time I went that I'd had in my sights for a while, but bought it for half what it would have cost on discogs (like an eBay/catalog for music). Or the Zimbabwean soukous album I just got that is super funky that doesn't exist online at all, and I'd never have heard had I not picked it up in the record shop for a listen.
* looking at cool things that I won't easily find online but probably also won't actually buy (e.g. the €70 original pressing 1970s Ghanaian highlife, or any other unusual rarity)
I'm super passionate about music and I love everything about the physical aspects of vinyl, so hopefully now you can see how ridiculous it is to suggest that record stores are useless because Spotify and the like exist. I'm listening to Spotify all the time too, but I definitely love my records more. I'm definitely not the only one.
No, I haven't yet. I do have a good phono preamp with a digital output for digitizing records that I got as an open-box deal. I have one album that doesn't exist online anywhere so I've been thinking about uploading it to Youtube, but I really adore listening to the physical format at home. At work I'm always listening to Spotify or something.
I tend to curate my record collection to albums I really love, so often it happens that I'll seek out something on vinyl that I'm already familiar with.
I find it much easier to discover something I don't know but enjoy if I purchase. A bookstore is fun to browse too but I find the chance of success much lower and the investment much higher. I guess it all does depend on the type of store you try. Large retailers are going to be a much different experience than small niche stores although both have their pros and cons.