There haven't been many instances where I sold a game and felt the desire to go back and repurchase it. Nearly all the games I've sold out of my personal collection have either fallen into the category of 1) rare, mediocre game that I was proud to add to my collection, but would likely never play, 2) Game I knew little about other than people online said it was fun or maybe it just had an interesting cover (lots of JRPGs included in this category), or 3) a game I knew about and liked, but it was a double that I held onto because it was a different port or release variant. As you can probably guess, none of these games made me yearn to add them back into my collection. There have been a few exceptions to this, however, mostly games that fell into category 2 that I thought I wouldn't miss, but ended up really wanting back. Einhander, Metal Gear Solid, and Timesplitters were all examples of this. But in general, if I sold a game, there's a good chance I'll never try and buy it again down the road.
As for re-releases and compilations, I'm generally a big fan of these as long as the games remain faithful to the original other than obvious quality of life improvements. I appreciate the accessibility and convenience of these releases, and in some cases I'll end up selling the originals if I own them. I mostly game on modern hardware, even if that's using that modern hardware to play 30 year old games. It's a lot less likely I'm going to hook up my Genesis or NES to play a game when I can just throw in a compilation and play the game on my PS4 or Switch.
