Canon A620 looks very nice with 4x optical zoom and 7.1MP. 2" flip out and rotating LCD. http://www.steves-digicams.com/2005_reviews/a620.html

Nikon has the Coolpix S4 with 10x optical zoom and 6MP. 2.5" LCD with swivel body (no optical viewfinder on this model). It's also tiny. http://www.steves-digicams.com/2005_reviews/s4.html

Those would likely be my picks for swivel functionality in and around that price point and size.

Bruno