I still remember getting goosebumps from Baldur’s Gate 2’s menu theme back in the day. It really set the mood and made me excited to start.

A more recent main menu theme that impressed me was Hellpoint’s. Together with the menu showing that black hole - it is just wonderfully ominous.