A great article over at Gamasutra about the planning and process from design to execution of the levels in Max Payne.. a great insight ! Read it here!
*update* eh... they seem to have pushed it for subscribers now. Hope you caught it while it was there. :)
*another update* well, you can still view it if you register (it's for free)..