There's nothing crazy about 200' on air, aside from the speed with which your deco obligations accrue. It's not so deep gas density is a big issue, nor is the 1.48 ppO2 huge, and the narcosis is generally quite managable. There are lots of good reasons for inexperienced divers to stay away from diving to that depth, but it being a "crazy adventure" isn't one of them.
What do you make of the quote in the DAN article I posted above that suggests that the impairment a diver has to "manage" may not be due to any one factor but rather the combined effects of narcotic gas, CO2, higher PPO2, higher density, and even sensory deprivation and increased stress (presumably from simply being so deep)? There are so many unknowns. I wouldn't stop at saying that "inexperienced divers" should stay away from combining so many unknowns but would say something more like the only divers who should remotely consider diving to those depths should be those with a LOT of experience diving to increasingly greater depths and figuring out how they handle the effects.