I have to say, the 737-400/757-200/A330-200 all have wonderful take offs.
But for leisurely and cool take offs, I have to say that I loved my 747-400 rides for this very reason!
My A340-300 ride from LAX
at night was awesome, it seemed to make a lot of whining, which is kinda cool. But It wasn't as good as the aforementioned aircraft(s)!
It's a shame that I never got to experience Concorde in her glory
Sadly missed indeed.