Here's a good example of being carried away:
http://www.youtube.com/watch?v=c1T7j_PIhew

Yow, being able to bob around totally out of control in a river is supposed to make me want to buy that snorkel? I kept waiting for the vehicle to catch on something and roll over.

thats actually not how a clutch fan works. a clutch fan is controlled by temperature, when it gets warm enough the clutch engages. It might cool enough to allow slip, but then again it might not, it could get filled with water and get stuck since it wasn't designed to slip.

Depends on the clutch. There are two main types, thermal and non-thermal. The thermal type uses a temperature sensitive spring to control the fan speed. A non-thermal clutch just uses a fluid coupling that slips as RPMs go up. There are also hybrid versions that combine both aspects. I have no idea what GM uses in an '06 Suburban. They've used a couple different setups. Regardless the fan shouldn't have a problem with water sending the blades into the radiator, as the design of the fan doesn't allow the edge of the blades to warp or bend (unless it outright breaks).