Games like Quake 3 are played by thousands of people to the his day. Single player titles such as System Shock 2 and Empire: Total War are are played and talked about to this to this day. 9 years on, Diablo II was still sitting in the top 10 selling pc games list.
Starcraft? No explanation needed.
If a game is loved at the moment the nobody gives a shit after a very short period of time (the Titanfalls, the Uncharted's) is this a sign of a title being overrated?