Well Timesplitters 3 had a fairly long single player campaign, took even longer if attempting it on hard -_-. But yeah that and all of the challenges and such, this makes TS3 a fairly long game singleplayer wise.
Also what about GTA San Andreas, as most GTA's, allows you to keep unlocking more...