The Short Ram Intake's are going to *sound* the best; but as far as performance goes you might as well keep the stock airbox instead of an SRI. (In my opinion).
If you want a good mix of a good sound when you stomp on it, being CARB legal, and actual performance increase.. I'd say go with the AEM Cold Air Intake. I don't know too many people who have ever experienced Hydrolock, and none personally, so that shouldn't be a problem. If you are worried about it though, you can get a bypass filter for the AEM CAI that will help prevent that in case you do dive into a 3FT deep puddle of water by accident.
Now, for my personal opinion. I'd go with the Comptech Icebox and keep your stock Airbox for smog-test days.
I should note, I had an SRI.. and I still advocate the AEM CAI or IceBox.