The word "hard" is funny. It's the opposite of "soft"... and of "easy". But not always the opposite of both simultaneously.
The word "hero" is the same way. It's the opposite of "villain"... and of "ordinary joe", or some one-word equivalent that I'm unaware of at the moment. A hero can just be someone who excels, or a hero can be an embodiment of all that's right and good. In much literature, a hero is both, simultaneously.
But if you decide to play an RPG in which you are not a hero, that might not mean that you are a villain or even an anti-hero; it might just mean that you want to be a mostly-decent citizen looking for a little success. Someone who's not already famous and exemplary.