I have been collecting since the mid-90s and used to want every pressing/variant for all of my favorite bands. I probably went way overboard on some of them. I loved listening to my records, but I eventually became a collector.
Then, my entire collection and 2 turntables were completely destroyed in a flash flood. For months I couldn't even think about it, let alone how I was going to replace them all (the insurance company would not cover them, or course). Finally, after about 11 months, I replaced my turntable, but my method for buying records changed completely.
Now, I only buy LPs from my favorite recordings, the ones that I really want to listen to on vinyl (more than just once, and no purchases just to know they are in my collection). To boil it down, I made a "desert island" list of albums, and went from there. The worst part is the random records I paid around $15 for when I bought them new, and are now going for over $150 used. Aside from that, I now spend more time listening to the records I love, looking for the great albums I don't have on LP, and zero time worrying about my discography on the shelves.