I have the "RealTruck BAK Revolver X4s Hard Rolling Truck Bed Tonneau Cover" and it has worked very well for me. It is not completely water tight, and when it goes through the car wash there are some drops that get inside. But even during heavy rain it has kept most of the water out...
I am having the same issue from another post (Power outlets don’t work (update: blown fuse #34 in bed and #32 in center console cigarette lighter outlet)). So I went to the fuse box to check the fuses, took the ones out that the manual refers to the outlets (Fuses 32, 33 and 34) checked them...