Well, I have a problem with the concept of "overrated", but as Vigor points out, the OP is asking for opinions, so whickering away about how poncey it is to consider something overrated to begin with is kind of needlessly antithetical.
So, let's see some of the common ones. I'll try concentrate on contrasting common complaints against common praises, to elucidate how certain games have appeals that might not be universal, so rather than being "overrated" perhaps they are just not for you. I'll bold titles that I myself bitched hard about.
1. BIOSHOCK INFINITE
Why they hates it - Bad gunplay, "plot holes", arguments the game was thematically hypocritical
Why it appealed - As a story it was an emotional/character driven piece about redemption, not a rube-goldberg puzzle about multiple dimensions and alternate realities. The science fiction/fantasy was secondary to the characters and themes being explored. It was also aesthetically beautiful.
2. MASS EFFECT 3
Why they hates it - One of the worst endings in modern fiction, lots of janky engine issues, pacing problems
Why it appealed - Some people did very well at viewing the entire 30 hour experience as an extended "ending", others liked the attempt if not the result to do a hard left turn into "thinking man's sci-fi" from the previous space opera. Some just liked the multiplayer.
3. DARK SOULS
Why they hates it - Repetition, repetition, repetition. Shitty controls. Washed out graphics. Opacity.
Why it appealed - The Sisyphean nature of the game play combined with the melancholy atmospherics made it one of the rare games to communicate complex emotions (sadness, dread, loneliness) without relying on traditional narrative formats.
4. SKYRIM
Why they hates it - "Width of an ocean, depth of a wading pool". Shallow RPG mechanics.
Why it appealed - It's a mod-friendly sandbox and seems to delight actual roleplayers. This is true of all Bethesdas games. Those interested in systems-heavy meta-gaming often find them befuddling embarrassments to the genre, those capable of willful suspension of disbelief and immersion find them near bottomless rabbit holes of entertainment.
5. THE LAST OF US
Why they hates it - Shockingly shitty/formulaic game play for a "survival" game, lots of QTEs, cheatin' AI
Why it appealed - Like Infinite it's a game where game play takes the back seat and lets story and characterization take over. Both of them are stories about bad men, father-daughter relationships, and redemptive paths. They are both differently cynical. I found Infinite the more elegant, less frustrating title, but they share a lot of strengths.
6. THE WALKING DEAD/TO THE MOON/GONE HOME/ETC
Why they hates it - It's not even a gaaaaaaaaaaaame / it's part of a SJW conspiracy
Why it appealed - Oh just shut up you plonkers.
7. HALF LIFE/HALF LIFE 2
Why they hates it - It's 10+ years old and the game play is no longer revolutionary
Why it appealed - At the time of their release, the game play WAS revolutionary. Both titles were masterworks of pacing. While there is little to no character or storytelling in either title, there's pretty strong indirect storytelling/ambient storytelling through good level design.
8. ANY MMO, MOST PARTICULARLY WOW
Why they hates it - They knew a guy who knew a guy who got addicted once, the game play is repetitive
Why it appealed - The better designed ones DO appeal to the systems/meta-gamey crowd, and offer nigh bottomless content for people who relax easily into reward loops. Even the least grand amongst their number tends to offer in the hundreds of hours of game play.