This is obviously a late answer but:
* The videos on Youtube seem great.
* This part is held in position by an adhesive and from reports I've read here and there there's a history of the adhesive not being strong enough and the camera comes loose from its position. There's probably nothing wrong with the camera itself.
* I have this problem and I am planning to at least try to reattach the camera at some point. The trick will be to find a comparable way to glue the camera back down without resorting to something ultrapermanent like superglue. "Just sticky enough"
* Disappointing to hear there's no obvious replacement part available -- I was considering trying to even upgrade the camera if the connection was something standard. It's a mediocre camera on an otherwise amazingly great device.