It can work very well, some examples including:
Dr. Gordon Freeman from Half Life, Doomguy/Doom Slayer from Doom, Point Man (from F.E.A.R.), Jack from BioShock, and Corvo Attano from Dishonored.
However, it can be done oh so horribly wrong.
It depends really.