I only started caring about what happened to Vito, and to a bigger extent, Joe, after he gets made, which is surprisingly late in the game. It feels like there are three or four chapters that were condensed into a "the good times" montage after the ceremony. As soon as Vito gets made, everything falls apart, so we don't get to enjoy any of the benefits of Vito's mafia success. The house burning comes - what - two chapters after you get the house? Jesus.
Vito suffers from game protagonist cypher syndrome. He's by far the least developed and blandest guy in the whole game, which is ostensibly because 2K wants the player to project themselves into the character. I don't want to follow around a blank slate for twelve hours, though. Had we been following Joe the whole time, I think things would have been much more interesting.
The few story events that wipe out everything you've built, like the prison chapter or the house burning, might have been more effective if the game were longer, or if it actually gave a shit about having Vito accumulate wealth. I liked that Mafia II tried something different, but the execution was flawed. There are a lot of pieces missing here.