Of all of those, the Mazda is the least craZAppy.
I don't like the Cavalier/Sunfire. They handle like crap and I don't like their interiors or styling. The low-tech pushrod engine is a dog.
I'd pick a Saturn over the Cav-Fire, but not a SC1. Those engines are also weak and run out of breath real fast, as they redline at something like 5000, but torque (and therefore power) fall down well before that.
I rather like Neons, they handle quite well and their 16 valve engines are strong for a little car, but their electrical integrity apparently leaves something to be desired, not to mention the head gasket failures of the first several model years. I know you?re looking for a manual, but I thought I?d add that the 3-speed automatic is unacceptable.
I agree with others, check out the Prizms and Corollas. Very solid, reliable, comfortable and almost bulletproof.
No comment on the Metro, except to say that people looking for good mileage without giving up performance or their dignity usually sway toward a Honda Civic DX, LX, VX, or HX.
EDIT: Oh yeah! The Sentra is another good one, but you have to get the 5 speed. The automatic Sentra feels like a dog unless you're at 90% throttle all the time. The 5 speed has enough pep from the 115 HP, 1.6 L VVT engine in the (95-99) and good mileage too.
PS: the 95-99 200SX is the 2 door version of the Sentra.