I bought the Bakflip G2, Haven't received it yet so I cant tell you neither here nor there as far as water resistant, but it does fold all the way up and out of the way giving full access to the bed. I paid $630 shipped to my door.
I almost went with the Access Laredo (decide I wanted a hard top), as my cousin who works at a Vehicle Accessory store highly recommended it. My Dad-In-Law has it, and it looks very nice, rolls up quickly, and keeps the water out. They are right around $300.