No doubt Roth was incredibly clever and resourceful in Godfather 2

I reckon, in terms of most irreparable permanent damage and most significant adverse turn of events were caused by

Godfather – Carlo and Fabrizio
Godfather 2 – Fredo and Rocco failing to secure Tahoe
Godfather 3 – Vincent including failing to secure the safety of the Corleones