David M's post raises the question..."how many of us on this forum are scuba divers?". Speaking as one, I'm not sure what the thrill is of free diving to xxx'? I understand going for a record (what is it now, some 400'?), but going straight down, with a rock weight or whatever, on one breath, then trying to make it back to the surface...does that provide something rewarding?
On the subject of narcosis, I believe the number where this begins is around 140-150', when Nitrogen absorbtion starts to mimic alcohol. It feels very much like driving home after leaving the pub having had a few. You're aware you're not at 100%, and are being (hopefully) a little careful, as your thinking is recognizably slowed.
Hence PADI's recommended sport diving limit of 135'.
The biggest pain in decompression diving, as David alluded to, is the loooong decompression stops. We dived (by sheer chance I was one of the first 4 'civilian' divers to visit the Bikini wrecks) to 180' on normal compressed air, spent just under 20 minutes bottom time, but then had to decompress for almost an hour, and that was on pure oxygen (20 ' stage) from hoses hanging from the dive boat (I think 20 minutes on oxygen, 5 minutes on regular air to avoid O2 poisoning, then back to 100%). BORING!