The top answer for this would be Twilight Sparkle. She’s a powerful magic user, and being a guy who tries to be earnest and open with his emotions, but at the same time comes from snarkasm central New Jersey, I very much relate to her personality.
Also she’s adorable and cute.
Second would be Spitfire, and not just because she’s named after a sexy airplane (the pony is pretty sexy too). Being a Pegasus would be awesome, and Spitfire, at least in her older season incarnations, just had that perfect balance of skill, wisdom, and athletic booty.
Yes I do like the athletic Pegasus booty.