I have to say that a sp game won't make me bored as long as it has a good story. Like right now, i'm playing through GTA Vice City for the first time, and i'm enjoying it. The story is pretty interesting and keeps me going.

Or if a game has something to work for and is genuinely fun, like BF2 - i want the L96A1 sniper rifle, and i will have it!