$10,000 Camera VS $100 Camera, Comparison Underwater. How much do you need to spend?

We took 4 different cameras ranging from $100 to $10,000 for a dive to test out which was best and how much a person really has to spend to get the footage or photos that they want.