If you're looking for deepest place on land it would be the Dead Sea which is -427m deep.
If you're looking for the Ocean one there is a tourism organized by Deep Ocean Expeditions, which you can pay a pretty penny but explore like James Cameron down to the depth of the Mariana Trench...
If you're looking for something more or less reasonable as far as prices are concerned take a look at R.I.D.E.