What song has really drawn you into a game, perhaps even more than the visuals, and really just immersed you in it?

I'd have to say Shalebridge Cradle from Thief: Deadly Shadows. Anyone who has played this level will understand why.