Aerodactyl is illegal in UU, so of course it'd be overrated.
I know he's useless as anything other than a suicide lead and, weirdly, as Sandstorm-staller. But he's still cool, particularly in the games.
I don't really consider him a dragon, in that he's a dinosaur, like Tyranitar, and also has no dragon-like features really. However, Lance uses one, Red (PokeSpec) uses one, I use one, so I'm not going to complain about his status, as inside of games, like I said, he's as powerful as a dragon.