The Panasonic AE7000 is exactly what you are looking for and all the rage right now with both critics and enthusiasts in low-moderately priced projectors.
It is not built like a Roland amp, and needs to be used in low to no light, but otherwise an amazing picture, 16:9 aspect ratio, HDTV capable, and very low fan noise.
I have just installed one in exactly the application you described and I am having lots of fun with DVDs, HDTV, and X-Box in High Definition.
All of this on a 119" ?!?!?! (and can go even bigger) diagonal screen for < $2500 -- I got mine from projector superstore in Arizona.
Oh and even better -- although I too intended to install it over the headboard, it has this joystick, lens aiming gizmo on the front to move the image up down and left right.
So you can probably just as easily use it from a bedside table.
This info and much more including reviews from users can be found on projectorcentral.com which is how I got up the curve on this subject.
Good luck and have fun.