I use Tolkien plus some non-standard species.
Humans, Elves, Dwarves: pretty much like you'd expect.
Half-Elves: As D&D norms.
Goblins, Hobgoblins: Rock colored skin (roughly as varied in tone as real rocks), small horns like sheep horns, wiry coarse hair, large mouths, pointed predatory teeth (obligate carnivores). Goblins are small and usually hunched backed, hobgoblins tall and muscular. In terms of "comeliness" the racial write up suggests that most goblins find even themselves ugly, but that the most attractive goblins with symmetrical faces and more balanced proportions achieve a sort of noble barbaric splendor that some in the other races may find attractive. (Why goblins find themselves ugly is a campaign level secret, not known to most beings, including most goblins.)
Orine: Very attractive avian people, tall and muscular, quite human in appearance except for the eyes and feathers/down in place of hair. Humans, Elves, and Orine all find each other mutually attractive, but Orine can only procreate with their own race - leading to a lot of dalliances.
Idreth: Stooped back, thin, with long gray hair, and large noses, sometimes axe shaped and sometimes bulbous. Large feet and hands. Facial features inspired by the grain of a piece of wood on my closet door, vaguely resembling the Mystics from "The Dark Crystal". Body shaped like a hunched backed Marshwiggle from "The Silver Chair". Neither monstrous nor particularly attractive to other species, and in general they in turn do not find any other species either particular attractive or monstrous.
Sidhe, Pixie, Changling: Fairie races, closely related to each other. Widely varied in appearance, even within close lineages. There is virtually no "wrong" appearance a player could select for a Sidhe as long as they are roughly 3 feet high. A Sidhe that appeared like a halfling or gnome would be perfectly valid. Fairies with plant like, insect like, animal like, monstrous, sylvan or ethereal appearances would all be valid. Appearance often reflects alignment and personality and in NPC's spiritual/magical gifting. PC's can look however they like.
All other species are verboten as PC races, and in general most would never be seen in a civilized place. For one thing, they generally lack free will or varied alignment the way PC races do. All minotaurs are for example evil lesser avatars of a fiend lord, fully reflecting his sadistic brutal personality and continually craving the flesh of the innocent. All gnolls are similar. Nothing is just humans with bumps on their head, but in particular nothing that is not a PC race is remotely human in outlook at all. A nixie has vastly more in common with a human than any NPC monstrous race. Species absolutely determines your character outside of the above approved list.
In general, most of the above get along fine, but for real and valid historical and present reasons a lot of people deny that goblins are people. There are also a few societies that deny that fairies are people, and even the fairies themselves deny that the lesser fairies like sprites and atomies are people and are more akin to say cats. Cruelty to them is cruel, but on the other hand, too many feral cats can require action - what are you going to do? I should note that animals in my world are as intelligent as fairy tale animals, and that the world is very animistic. So yeah, if you want to eat a cow or a deer you have to had made peace with the idea you could have talked to that animal. See animistic cultural attitudes toward eating animals.
Technically, the "Giants" are varied enough and possess the freewill to be a PC race, and Hill Giants and Ogres even have mortal blood (effectively races of half-giants), but as they are generally too powerful to be PCs so they aren't allowed. The same is true of the genies (and gods!) from which giants are descended.
Sorcerers are a special case. Sorcerers in general are free peoples tainted or cursed with some association with a servitor race or some other monstrous thing. In most societies, sorcerers are treated therefore as being members of the monstrous race, and so sorcerers have to do their best to disguise or hide their magical abilities, pretend to be wizards, etc. They are not considered "people". Of course, individual attitudes can vary, and some societies are more open and cosmopolitan than others, but there are game mechanics that enforce "people really distrust you" if the sorcerer's supernatural powers are known. Think X-Men mutants.