Even out of water, they're not completely terrible. You miss out on cool racial features and rapid independent movement in exchange for decent stats and the water stuff. They'd make decent sorcerers or warlocks, and the movement speed issue can be avoided by simply buying a horse (or getting the fighter to give you a piggyback ride).