There's a zillion of them -- with fold-out and tilt/rotate screens. Seems to be a mid/upper market feature these days, though. The Canon-G[23456] all have it, and so do others.

The original Nikon Coolpix series had twistable split bodies for a similar effect -- I've still got my E990 Coolpix. And somebody else just recently put out a split-body camera, read about it on Dpreview not long ago.

Cheers