my experience is that unless you have quality grain wood, etc, solid pigment stain is hands down my choice for uv/weather protection, not semi transparent. in your case, sounds like you want a treatment conditioner rather than stain?
at the the end of day, whether oil or water based, lower end quality products will cost you more, good luck finding what you want...as a caveat, when i used Olympic oil based solid stain for several decades before switching to water based, Olympic oil based directions specifically stated not to use on horizontal deck surfaces. i did anyway with mixed results.
seems to me, regardless of oil or water based, when you have extended pooling on horizontal surfaces, you will eventually have problems. so build it right in the 1st place i guess, cheers