I think this applies more for movies/shows than video games. I just watched a video by Nostalgia Critic questioning the same issue and used Frozen as an example (link here https://www.youtube.com/watch?v=S9XR0v1LRE4 ). My Little Pony had a similar effect on me a few years ago, it was good but dear lord it was plastered all over the Internet.
I can't think of a single game in my library that's sort of an obscure gem and eventually got a cult following and exploding. Closest thing to this that comes to mind might be Persona 3 & 4. But I find this debatable because the game seemed to be pretty popular by the time I came around. Even then I didn't enjoy the game any less.







