GTA 4 is definitely such a big motivation-killer because of these issues. Apparently it used to have no checkpoints, but then when the PC port was released they added just one checkpoint per mission apart from the bank robbery which has a whopping two checkpoints. And in typical rockstar fashion like 99% of the missions start with really long walking or driving sequences, so I agree that it got really tedious on the harder missions.