Detonation is what kills these engines. In Honda engines with oem engine geometry the better tuned Honda motor will last longer than another engine with a poorer tune regardless of R/S ratio.

Honda's generally have low rod ratio's with the exception of the b16a engine. One of the things Honda did to minimize the side wall loading was offset the wrist pin opposite of the direction of rotation. In relation to the drawings above this increases the angle theta a couple of degrees. Now most of the aftermarket piston manufacturers fail to do this, the only one I know of who does this is Wiseco.