I dunno. Nothing really pisses me off mid-game. When I'm playing a game, and I get to a certain point I just like it. I find that complaining about a game after so many hours of playing it is just being a hater because things didn't go your way. Case and point: Peoples complaints about Star Ocean 3.
You're acting as if a game is perfect all the way if it starts good. There's always games with frustrqating bits. The rotating platforms in God of War, the money-making parts in Shenmue 2, the Water Temple in OOT... All games have their frustrating parts which [acid burst] people off sooner or later.
This in Spades. The only time I could understand touching an enemy and getting hurt is when:
A: They're attacking you somehow
Or
B: They have Spikes, or some sort of electric barrier.
Never once have I understood how ANYBODY can die from touching:
A: Something rounded and plush (i.e. Kirby enemies with a few exceptions. Sleeping enemy is a big offender.)
B: Something that isn't even moving (i.e. Standalone Turrets with no sort of shield or anything, inactive enemies, Shotzos from (again) Kirby.)
C: Shields, I mean, is it made of fire? How the hell can enemy shields hurt me yet my shield doesn't affect them one bit? (i.e. Mettaurs, Sniper Joes, Some Zelda enemies.)
D: Standing 2-3 pixels away from an enemy means pain? Why? (i.e. any game where collision fields are TOO [tornado fang]ing LARGE.)
Its like the developers are saying "[tornado fang] you for touching an enemy, instead of letting you be a bully and push it around you're going to get attacked and maybe lose something too."
But, as Superbat said, its been getting better, not by much but its improving. Of course Wario games are a neat perk to this, seeing as you can push your enemies around, but thats part of how the game is run. It fits for the playstyle.
I'd like to put a (dis)honorable mention for getting hit by an enemy, falling fowards (or backwards) and sitting on the edge, thinking you would be able to get up, only for the game to make you fall down from whatever you were on (i.e. ANY 3D Mario game, hell, most 3D games have this problem.)
As games go on, I think you'll find it hard to find a recent 3D game which still does this. Even in really hard games, enemies hurt you only when they attack, which is always a good thing. Aside from franchises which have it established, like Mario, where it'd seem kinda wrong if Goombas didn't kill you.
As games go, aside from games where it's logical that enemies will kill you at a touch (like schmups) and games which are either revivals or established franchises (Sonic, Mario, the recent Rocket Knight or Contra classics...), I don't think games will use that old logic again. We've evolved out of that with the dawn of 3D. And that's good.