Yes, race/species being cosmetic only would be a major turn-off for me.
However, if the DM was able to give me a decent enough reason why such is the case in their world, I would probably play something absolutely bonkers, like an anthropomorphized armadillo or hermit crab, or maybe a shardmind...