It's worth checking out how Amazon did their iPhone Kindle. When you initiate a rotation, it pops up a little button at the corner of the screen for about 2 seconds that allows you to lock that orientation. Most elegant implantation I've seen. It doesn't solve the issue of the user wanting to initiate a rotation without the accelerometer.