The Elden Ring Main Menu theme has always impressed. It sets the stage very well.
If I think of main menu music only one other game cones to my mind and that's Doom Eternal. I'm not sure if it's necessarily a "good" main menu theme, but the whistling definitely stuck with me.
I think we're going to see a lot more of those types of games in the future. It's pretty easy to make a decent looking game with UE 5 - still doesn't give it any soul though.