For me it has to be the title music of Shadow of the Beast 2. Pure atmosphere, gorgeous.
A close second would be Monkey Island.
Other favourites in no particular order: Beast, Cannon Fodder, Gods, Lemmings, Captain Blood (by Jean-Michel Jarre apparently).
Basically anything by the Bitmap Bros or Sensible Software are brilliant.