I read through a few of these reviews and the general analysis seemed to be that this movie sucks more than the lead character does in the back room of the Cheetah Club. Well, I guess if you take it at face value, it does.
However, it's not meant to be taken that way (internally, with a glass of water?), and it's a shame that so many people did. Really, 'Showgirls' is a campy, funny movie. It's a riot. And it's supposed to be.
Elizabeth Berkley, in the lead role, plays her part like an actress on one of those day-time soaps - which is probably exactly what Verhoeven wanted. She does everything dramatically. She sits down, dramatically; she takes off her jacket, dramatically; and if you watch closely enough you'll even see her eating fries dramatically.
Gina Gershon as femme fatale/lead dancer Cristal gives the best performance of the film. She obviously is in sync with the director and has a lot of fun with the part, and if you only watch it for one reason, watch it for her. Because, in the words of L'Oreal, she's worth it. She's a great talent and it's a shame she's not recognised more widely.
Would I recommend it? I don't know. It depends on your taste. If you're looking for a drama, go elsewhere. If you're looking for a quirky, funny movie, and you don't mind lots of naked ladies running around all over the place (yes, even if you're female - I am, and I liked it), go rent it. It might surprise you.
