You can't forget the masterpiece that is the Final Fantasy VIII opening. The music alone is amazing, but combined with the animation at the time just blew my mind.
Final Fantasy VI - the March to Narshe
Wild Arms (mindblowing at the time with the whistling)
There we go. Reposting because they're worth it. And FFVI is also fantastic.
KH2 has already been mentioned, but two of my favorites are:
Sonic Cd
More recently, Sonic Mania
Budokai 3 intro gives me so much nostalgia. Love that theme.
Best opening/cinematic ever, though:
You can't forget the masterpiece that is the Final Fantasy VIII opening. The music alone is amazing, but combined with the animation at the time just blew my mind.