If you're after something a bit more realistic, then Operation Flashpoint, or GRAW (Ghost Recon Advanced Warfighter) are both good but also quite hard... Single player is actually enjoyable to....
A little less real but not so hard?.... Delta Force series were ok..... bit more fun....
All depends what you want from the game really....
All the above a good single player games....