water is not going to get sucked into the engine unless you submerge the filter in water. chances are you wont hydrolock unless you drive through a flood.
all of you "heard of" instances...but have you actually "seen it" happen?
the only places i would worry about is where places that constantly rain a lot and flood a lot. otherwise your car will be fine with a CAI