Water-based that can last a little bit in the shower...

I've found Maximus lasts longer than most water based, simply because it is thicker.

The only way you'll get things to work for a while with water-based is to find a position/location where the water from the shower is not flowing right over the anatomy in use. Thicker is better, but they'll still rinse away fast if you're in the water.

Silicone is great for showers as long as you're careful to not get it on the floor, where it can be dangerous (any lube can be dangerous on the floor of a shower). Oils also work, but can bring their own issues.

i have found that wet stuff last pretty long in water. but like any water based lube, enough water will wash it away.

System JO and Gun Oil both make great water based lubes... but no matter what brand you get they will all wash away in the water.