I can narrow it down a bit.
I have a list of cameras with "articulate LCDs".

I don't know if they will swing all the way around to be seen from the front. You will need to check further to find out.

Canon: SX20, G11
Fujifilm HS10
Nikon P90, P100
Sony: HX1

And that is it.