Does HDR really look better than SDR? And, do I need special cameras to make it look good?

In this apples-to-apples comparison video, I present content originally mastered in SDR and presented in remastered HDR and compared with the derived SDR, shot on a variety of cameras without an HDR finish intent.

How does it look? That's for you to see, and to enjoy.