The character who is scared, cowardly, or not at all the heroic type(plus, generally unskilled) but comes through and helps in the end.

Lord Faren - Guild Wars 2(Somehow he always manages to get his shirt off.)

Emmet Brickowski - The LEGO Movie