My 2024 Mazda CX5 has been dead reliable as well. 2.5L, 6 speed tranny. Most people I know trade them because they are a bit smaller than similar SUVs. Not because of reliability issues.
Could be because since the o2 sensor is detecting a lean condition due to the misfire, it might be trying to load more fuel to compensate. So you have both a water entry issue (evidenced by the super clean piston) and a richer condition from the eco giving it more fuel.
I’d go one year oil and filter. Once a year (1000 miles) will at least allow the additives to bond with the metals a bit before getting washed away. No reason to go any more than this.
I think if one puts an "electronic" dipstick in, the oil tried and true manual dipstick should be included anyway. I'd pay the extra $10 it takes to put a dipstick in on the assy line. This would help ensure that people like me, who check oil quite often, could do that, and that one thing you...