Certainly. Black Ops certainly drove me to that trying to beat it on Veteran w/ several levels having infinitely respawning levels, and I eventually just put the game up rather than endure the aggravation.
I actually did beat that on Veteran, but I don't have the Platinum for it because of two zombie trophies which are impossible for me to get on my own, and trying to pull it off with random players so far hasn't paid off. I don't think co op or multiplayer trophies should exist at all. Trophies should be about personal achievements, so if you have to depend on someone else to get it what's the point?
I've also seen some really stupid co op trophies which have criteria such as "play a game with another player who has beaten the campaign". What the hell is the point of that? This trophy was in the game Red Faction, btw. The very first online match I played I got that, and it was a Gold trophy too. That's probably the easiest Gold trophy I've ever earned. Just play an online game and you get it, whether you win or lose. I don't feel proud about getting it, but I got it.
As for Black Ops on Veteran, the hardest part for me in that whole game was the 3rd or so mission where you are at this Russian base thing, and eventually you come to this part where there is this really long hallway and you are supposed to move forward but you can't because you move out of cover and you get killed killed instantly, but you can't stay where you are either because then you get spammed with grenades which you can't evade or toss back because there are multiple of them. I swear I must have died on that checkpoint at least 50 times and I swear I'm not exaggerating. It really was that bad. Maybe that's the part where you gave up, and if it was I don't blame you.
But what saved me and helped me get past that was watching a video on youtube, and I just tried to duplicate what they did as closely as possible. It was tough, but I finally got it. But what really sucks with that one is it seems like there should have been another checkpoint halfway through. Distance wise it was probably like 500ft, but that's the longest 500ft you will ever walk in any video game.
After I got past that the rest of the game wasn't so bad. There was still some tough moments, but never anything quite as bad as that. Although near the end of the game at that same point where you get the trophy for barbecuing the Russians that was extremely tough on Veteran. You just have to keep trying and hope eventually you get lucky. But you are right the infinitely spawning enemies are the problem. Treyarch likes to do that in their games for some reason. World at War was also really bad like that.
To throw this thread back on-topic, though, I hope that Nintendo does implement some kind of system-wide achievement feature with the Wii U. Some folks here have major issues with achievement systems, but I've found in my experience that they really enrich my gaming experience & allow me to keep an eye on how my friends are doing at certain games.
I agree, it doesn't really hurt to include it. If people don't like it that's fine, but it doesn't do much harm for it to be there... well, I guess it does harm when you consider the lengths people will go through to obsessively obtain trophies. The time wasted and the stress and frustration isn't really a positive thing, but people fall into that trap of their own accord.