The main menu for Battlefield 3 on console is still the gold standard imo. Had atmosphere without being sacrificing usability.

Going off pure style points NFS Most Wanted 2005 always gets you in the right mood for the game, although having replayed it countless times I still fumble navigating the menus at times. So I’m aware it isn’t the most user friendly design.