The Pit on Halo 3 is the greatest FPS map of all time.

Honorable Mentions:

Guardian (Halo 3), High Ground (Halo 3), Arica Harbor (Battlefield Bad Company 2), Terminal (COD: MW2), Highrise (COD: MW2), Fuel Depot (Wolfenstein: Enemy Territory)