There are many DSLR cameras with articulated LCD screens but I assume you are interested in non DSLR cameras.
There is a short list:
Canon SX30IS, SX40HS, SX130IS, G12
Casio TRYX
Nikon P500, P7100
Panasonic FZ100
Samsung MV800
The Casio and Samsung are unusual designs.
..
what digital stills cameras are available at the moment with a flip out lcd screen? as an example, have a look at the Panasonic Lumix DMC-FZ100.

Chowhound
Comic Vine
GameFAQs
GameSpot
Giant Bomb
TechRepublic