If the bolts are not sufficiently tightened, they will see large variations in loading and will fail quickly by fatigue. Once the bolt breaks, the rod and cap will come apart and destroy themselves and several other parts.
Oil starvation will destroy the bearing and journal, generate a lot of heat, and cause the rod to fail. If it siezes on the journal it will bend.
If a piston is destroyed by detonation, the rod is likely to be all twisted and banged up as a result of being flung around and hitting other parts.
I once saw a rod that had a thin section that required shot peening. It got missed on this set, and it resulted in a nice fatigue crack through the section. The rod and cap were in several pieces so it was hard to find the source of failure. Along this line, any machined corners used for bolt head or nut clearance should have a radius, not a sharp corner, and in some cases should be shot peened.