I don't play them too often, but fighting games generally hurt my hands quickly.

As VeloZer0 mentioned, any Mega Man game where you constantly hold to charge gets me.

But what really got me about a decade ago was Luigi's Mansion. Good game, but the controls required you to twist your hands like a contortionist.