What I want in a main character...
I want the main character to be female. This isn't about equality or eye-candy in any way. It's simply that I'm tired of seeing guys getting the leading role in 95% of RPGs. RPGs with more female leads would be wonderful.
I want the main character to be competent. I want the main character to be good at whatever he/she does. If you're a monster hunter then you should be good at killing monsters and know a lot about it. If you're an air pirate, you should be good at being an air pirate. If you're not good at anything then you're not good enough to be the star of this game.
I want the main character to make intelligent decisions. Do not turn your back on the guy who is 99% likely to put a sword in it. Do not go into the forbidden forest of doom without a plan. Do not do stupid, face-palm-worthy things that the player knows you'll regret in less than 5 minutes. I'd like writers to stop making RPG characters do stupid things because they themselves are too stupid to write their event into the plot in a clever way.
I want a main character that knows how to make an entrance. We don't play RPGs about lumberjacks who sit in the wood chopping trees because they're boring (well, maybe MontanaHatchet does). We play RPGs filled with excitement and cool, interesting stuff. It's not enough just to do it right, you have to do it really right... with style.
I want the main character to be a hero. I'm tired of down-to-earth characters. I'm tired of emo/whiney characters. I'm tired of anti-heroes. I want someone of good character and morals who stands up for her beliefs and fights the good fight. I want the legendary hero of old back.