Rarity got wings in the Sonic Rainboom episode, granted it was a difficult spell, but it's possible. If you want dexterity like humans have then you'd want to be a unicorn, seeing as they easily levitate and pick stuff up with magic. I think I would prefer a pegasus because I love freedom and flight.