Of women: notably there was a really hot one named Sunny, who was the valet for three or four different tag teams, who was so much more over than the teams she managed that they eventually had her only as a guest ring announcer (and doing modelling shoots). She got fired for being a (legitimate) crackhead, and she also has had a rocky (no pun intended) post-wrestling career. She doesn't do porn for drug money like Chyna did, though.
A little later on in the Attitude Era there were Lita and Trish Stratus, but yeah, I don't really get the appeal of a lot of them (actually Miss Kitty was delicious). Terri Runnels in particular looked middle-aged when she made her debut and her (fake) tigolebitties were simply grotesque on top of it.
Like half the WWE roster nowadays are women, and selected more for their wrestling skills than their looks. Sasha Banks is really hot though.