For home use, Logitech have just recently released a webcam for this: https://www.logitech.com/products/webcams/brio-500-webcam.ht.... Built in tilt stand and an internal vertical image flip when pointed down.

For commercial setups (or personal use where money is no object): https://wolfvision.com/en/products/vz-c6.