There was a fantastic Kyocera digital camera years back, where the lens portion swiveled independently of the body Link to review from 2004. They were great for taking photos with the camera held high overhead, down low, or surreptitiously on the street (because you could look down at a flat object while the lens was pointed ahead).
I always wondered why no one else went with that form factor. It probably didn’t help that Kyocera got out of the camera business immediately following its release.