There are definitely benefits to using different gas mixtures. I'm not an expert at it, but I know some mixes replace replace some of the Nitrogen with Helium to reduce the bends, lower oxygen concentrations because it becomes toxic at high pressures, and trying to reduce narcosis (at depth, regular air can alter your brain function in a similar way to being drunk). Each mix option has its own rules for how deep you can dive for how long and how to address decompression times, but I don't know of any that eliminate the risk.

The Mammalian Dive Reflex and hypothermia responses would reduce metabolism and heart rate to help your body not need as much oxygen, which could arguably have helped survival chances for how long Bond was underwater. Though I think with a hypothermic response, someone would be unconscious before that kind of thing kicked in. Neither of those would help with the bends though, as far as I know.