One-Scene Wonder: Norm Macdonald as the overly inquisitive mob member. Often cited as the funniest (or, depending on how ungenerous you are, only actually funny) scene in the film.
Squick: Lots of things, but especially the goat joke.
The scientist making his own woman out of animal parts is pretty squicky too. Possibly justified as the scientist has had some animal work done on himself too...