Clips reveal that kayaking down rapids, scaling tall buildings and pulling handbrake turns can all have dangerous or humiliating consequences. Richard Hammond investigates why.