You know, it builds, it builds, it builds…and then reaches a definite point where it’s at a climax and then, afterwards, calms.
I mean, the obvious one is Bohemian Rhapsody…
But I can think of a few others such as the brilliant one in White Rabbit, the shiver-inducing one in It’s All Coming Back to Me Now and the instrumental one in Light My Fire.
But, c’mon, there has to be hundreds more, right?
Paradise By The Dashboard Light by Meatloaf.
American Pie by Don McLean.
I can’t Live…Harry Nilsson
Most will not like this answer because I think it is everyone’s favorite song to dump on:
The whole song is a slow climb to higher energy, reaching a crescendo and then, at the very end, it brings you back down. Full circle.
I get people dumping on it because it was overplayed and people got sick of it but it was over played for a reason.
“Where No One Stands Alone” - Alison Krauss
Great Gig in the Sky.
Television’s “Marquee Moon” has one of my favorite guitar solo build-ups ever. It’s positively orgasmic.
I always liked Christine’s belting towards the end of Phantom of the Opera (the theme song). It’s a lot of fun at karaoke especially, whether they nail it perfectly or just make a fool of themselves 
A lot of Evanescence songs have a similar effect.
Slightly eclectic, but I love the build-up in Coin-Operated Boy, which builds and builds and builds into an orgasmic crescendo 2/3 of the way through before gradually coming back down to earth.
“Let There Be Rock” AC/DC
“The Music Never Stopped” The Grateful Dead (live)
A recent example: Olivia Rodrigo’s “Bad Idea Right?”.
I thought the obvious one was A Day In The Life.
Nineteen Hundred and Eighty Five by Wings
Magic Bird of Fire by Salsoul Orchestra
Does classical music count? Because Tchaikovsky’s 1812 Overture definitely fits.
Does “Nessun Dorma” qualify?
The ending is positively orgasmic.
Love Reign O’er Me…sort of. After Roger’s belts out the last line, there’s a pick slide and multiple cymbal crashes–and then it fades out on a synth note. But listen closely at the very end and you can just barely hear Keith trashing his kit.
Movement IV of Scheherazade by Rimsky-Korsakov isn’t exactly a “song” but it is the ultimate musical climax. It keeps building, doubles the tension and builds again, until you’re holding your chair arms with tight white knuckles… then when it finally breaks and those HUGE wave phrases come in… I used to crank the family stereo to 10 and sit in front of the speakers. [recommended: Leopold Stokowski’s 4F 1964 recording]
Vampire is also a great example. Each verse builds the intensity higher.
Poorboy (The Greenwood) from Eldorado - a Symphony by the Electric Light Orchestra
This is just before the intermission, so off to the restroom with you.
Yes’s “Starship Trooper” is the first one I thought of. The final movement just builds and builds in intensity with that descending riff and then sort of “explodes” when Steve Howe starts his guitar solo. And I hope I’m posting this correctly to get it cued up to where I want it to start. If not, go to 5:35.
