Hojo is an insane lunatic Cloud and Vincent got they're revenge
Cloud: Hojo claimed him as a failed Sephiroth clone and maybe responsible for the Mako and Jenova cells within him

Vincent: used Lucrecia and shot him in the head, then experimented on him making him cursed and having to live with it forever