Will give you my opinion, I prefer oil based sikkens.
There are other brands to use, this is just my opinion
Anytime you have wood outdoors, it will need maintenance. It does not matter if you paint it or stain it, will need regular maintenance to keep it looking good and protected.
If I had paint, it would be much harder to maintain, the weather will get to it, people walking on it will wear the paint, you will need to scrape loose paint to prepare it for new paint, the list goes on of preparation for repainting a deck.
With a high quality oil based stain, and I prefer clear for a more natural look, sikkens will turn a nice colour after a few months.
Butt after a couple years, some areas will be worse and these are the areas that get the most sun and weather, you will be able to see the difference in the wood, will say to self that it is time to apply more oil to it.
Is just a basic cleaning, then re oil.
Just the chore of maintaining a nice looking deck with oil is Sooo much easier then trying to maintain a painted deck.