Castlevania is filled with many memorable ones. I also like most of the Nintendo franchise themes, and a few SEGA games namely Sonic Rush and Jet Set Radio. Atlus' Shin Megami Tensei games have some smooth tracks, along that with Suda51's No More Heroes Oh but for main theme? Metal Gear Solid, especially Snake Eater.