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.

The only caveat is you have to mostly avoid AAA and other cheap trend seekers to find refreshing gaming experiences. But otherwise, I agree with you.