Forza 2 career mode becomes repetitive for me, but then again I am not a huge racing fan. Test Drive: Unlimited was more my cup of tea, and can be picked up for a tenner pre-owned now.
If you are definitely not going to play online, an Arcade console will suffice - and you can get one brand...