It all comes with a drawback, doesn't it? That's kind of the point of these comics anyway.
Scrooge is so rich that he can't sleep, constantly worried about people trying to take his fortune away, and if he started spending it, he'll not be the richest anymore.
Gyro is a genius but impractical, and his inventions have a tendency to go awry.
Gladstone is always lucky and therefore not particularly well-liked by others, also he has no sense of achievement
Super Goofy has superpowers but he's clumsy and not particularly bright
Magica is never satisfied
...
I think I'd go for Super Goofy's powers because they're awesome, on the other hand they're not just unrealistic, but also come with responsibility.