Hmm, that's a tough one. I'd have to go with Kyle from Rune Factory 2 (yes, it isn't strictly a Nintendo game...). He's strong, can use magic, and unlike a lot of the characters you mentioned, can actually get married and start a family. I don't want to be Mario, forever teased by Peach with the promise of cake.
As far as actual Nintendo characters are concerned, I'd have to go with Giima from Pokemon. Dark type represent, yo!