Not sure about the Hero but on my HTC Magic the Accelerometer is perfectly capable of turning the phone screen to the Right and detect if it was even upside down. It simply depends on the app and if it supports the Orientation angle.
Unfortunately I don't know of any app like messaging or email that currently supports it {right side , upside down orientation type thing} . Anyone else got any ideas?