Halo 3: ODST

[Madame Adequate]

Depending on what difficulty you want to play it on, you'll likely get anywhere from 5-9 hours play time out of the campaign mode. That said, I'd never recommend buying any Halo title as a purely single-player experience anyway.

The original Halo is an exceptional single player experience but yeah the others you need friends for.