This might be too much information but I need to explain my rationale....
I had all carpet in my motorhome. A fuel problem created the need for cutting a hole in the floor in order to access the fuel tank. I cut out the carpet in that area (it was a hallway), put down new subflooring (after the fuel line repair) and then installed peel-n-stick vinyl. As someone else mentioned, the peel-n-stick vinyl slides around and the gaps get bigger revealing adhesive and all the junk that sticks to it.
After that - about 2 years ago - I put Pergo flooring throughout the rig. It has proven to be extremely durable and has weathered the extreme temperature changes without any hint of a problem. Naturally it's a bit more tedious to install but I think you'll be much happier with the results.
As far as water issues go, I've had the A/C leak a significant amount of water onto the new floor without a problem. The instructions say to get to it quickly. I had a leak at the entry door that went unnoticed and caused it to buckle, but it was just on a step and easy to replace.