Some games do have ridiculously obtuse and obscure puzzles but many games like Beneath A Steel Sky have logical puzzles which just takes a bit of thinking. The biggest problem is missing out on an item to pick up :P UHS really helps there though - gives you gentle nudges.

I'm playing through Psychonauts right now, and i have to say its one of the most frustrating game experiences i've ever put myself through. While the game oozes with charm, the actual gameplay and level design is horrible. Don't even get me started on the camera. Plus, I just don't think the story is really that great. Maybe theres a twist at the end that i just havent seen yet. I guess i just don't understand why people rave on and on about it.
While we're talking about things we hate, something that really pisses me off are snobby gamers who refuse to like games because they've become more mainstream. Gaming audiences are changing, but games really aren't. The quality of games isn't declining as time goes by, they are just becoming more streamlined and accessible.

Top 3 Hated Games:
- Need For Speed: Pro Street ... A $2000 computer re-build & this game still runs just as shit as before.
- Halo ... Its a lame horse that should've been put down.
- HL2 ... A good game ruined by steam & the change in the games world/plot setting >_>

C&C Generals
The only game I've ever bought for $90 and had installed for less than 24 hours before deleting it and giving the game away. Its easily the worst and sloppliest game I've ever played. I think it was chinese mission 6 that you could LITERALLY finish in 2 clicks and a bit of waiting.
I personally find RTS too annoying to play most of the time for the simple fact that no matter how good you are, the AI doesn't have to cope with the same clunky interface that you do and that pretty much gives them a massive advantage (assuming the AI is reasonably well made and not a drooling tankrushing idiot) and it just gets to a point where it becomes more annoying than fun

World of Warcraft
Kinda loses its charm after doing the same daily/instance for the 100-200th time

C&C Generals wasn't that bad for me although you're right: it had weird balancing issues in single player. The missions felt hastily put together and the difficulty spikes didn't help. Still, I can think of much worse games in that genre.

Games I hate? Almost every MMORPG released to date. People are still playing to MAME and old DOS games these days, but when the World of Warcraft servers will be off the fucking meme will be buried in memories, static as much as a JPG image can be.
Monolithic MMORPG are shit. Long live to single player/dedicated server multiplayer games! :-D

While I actually kind of liked C&C Generals for a time, I'd agree that the single-player scenario was very sloppy in terms of difficulty. It really felt like it was more of a multiplayer game with a token single player scenario just thrown in for kicks.
Other games I disliked:
Pax Imperia 2: Eminent Domain - this game was a huge disappointment for me. Like Master of Orion 3, it felt like the designers were so obsessed with packing in micromanagement details in the game that you ended up with a game that practically played itself.
Halo - I come from the Mac side, so the whole Halo saga struck a raw nerve with a lot of veteran Mac gamers back when Bungie was one of their most well-loved developers. But really, while it was a good game, it didn't deserve nearly as much hype as it did. In many respects, other story-driven FPS games like Marathon, Half-Life, Deus Ex, and System Shock were a lot better.

Call of Duty 3. So bad it hurt.

I really enjoyed Farhenheit, surely cause I give importance to the general atmosphere in a game, I liked the immersive aspect.
But on a pure games aspect, I've been very disappointed by all the QTE actions, too many of them, and you can hardly see what's going on on screen while focusing on it...
Games I hate? Resident Evil since the 4th one. Those game are not so bad in fact, but they have absolutely killed what RE really was.
I also hate all the recent zombie bashing games.

Yeah... replaying the "room is falling apart" QTEs a dozen times was not fun.... and the game seems to have descended into an excuse to show revealing shots of the female detective... lets see how it goes from here.
BUT, in general, I find it really hard to think of ANY games I hate. There were a few games that were disappointing (Jedi Outcast, Halo), and a few that didn't grab me (Fallout, so far, Starcraft). But I've found most games have some value, and if they are ones that i'd really dislike then I just don't buy/play them. I suspect I'd hate all the Hunting Sim games, but only if i'm forced to play them... which i won't ever be.
Parts of games that have annoyed me:
About 3 of the insanely hard levels in Driv3r - but i still enjoyed the game enough to beat them.
The level in Buffy the Vampire Slayer where the walkways are surrounded by an abyss and the enemies can kick you off.
The beginning of Warrior Within - fighting stupid dominatrix.
Having to replay entire levels in Ground Control.
Actually, other than the horrible change in style of Warrior Within, and the way Jedi Outcast didn't live up to Jedi Knight, my main problem with games is when they force me to replay things again and again. My time is valuable (kind of) and I don't like feeling I've jsut wasted 3 hours of it with no progress to show for it.
Oh Oh Oh! I thought of one I hate: Interstate '82! Ruined every single aspect perfectly.

Got to be Oblivion. Such a beautiful world, greatest music i've ever heard and everything ruined because of a stupid leveling system, lack of challenges, retarded story and stupid Fed Ex quests.

There are mods to fix the leveling thing.

I wouldn't call them quicktime events exactly, no more so than any other button press anyway. They seem to me to be just a different way of controlling the game