Intense or out of control, but typically in a good or fascinating way. The term is derived from a boxing metaphor - when boxers train on a heavy bag they can knock the bag "off the hook". Also see "knock him out of the box" for another popular boxing metaphor.
Did you see that Russian climbing video? Damn, those dudes were flipping off four story buildings! It was off the hook!