Getting the Summon Eleanor Plasmid. The weak, frail girl you've been trying to save throughout most of the game is now a Big Sister who can rip enemies to shreds, taunting them the whole time.
Even better, as far as the splicers are concerned, this is their Messiah personally killing them while mocking their religion.
Anything Eleanor says while fighting as a Big Sister.
"Stay away from my father!" "This one died alone and afraid! Stand in our way, and you'll get the same!" "Just try to stop me protecting my sisters. Please, try!"
Eleanor uses telekinesis, yanking a splicer across the room onto her needle! What does she say?
"I am not your bloody Messiah!"
Learning the 'Drill Charge' technique. Remember the Bullfight Boss that the Bouncer Big Daddies were in the first game? Well, you are now the bull.
The Handyman tonic. Suddenly your hacked security bots turn into true bros who lay their very lives on the line for you.
If you let Grace Holloway live, she realises that you're more than an unthinking monster and decides to help you out - and, as Subject Delta massacres his way out of her HQ, accompanied by a swarm of donated security bots, blasts a full-on rendition of her signature hit over the PA system. Looks like someone's had a weight lifted off their mind...
The evil ending. Ruling the goddamn world together as father and daughter? Shit yeah! Daughter, I am not disappoint. (Not to be confused with the pure evil ending where Eleanor takes Delta's ADAM against his will).
Porter's response to Lamb's invitation into the Family. He may not have known what Lamb was up to, but damn if it doesn't feel good after what she did.
Porter: Dear Doctor Lamb, I received the invitation to your little social club today. In return, I'd like to make you a wager: I wager you need Rapture Central Computing just a little bit more than I need your half-baked metaphysical mumbo-jumbo. I deal in science, not...whatever it is you're up to! You keep out of Minerva's Den and I'll keep this city's automation from grinding to a complete and sudden halt. Sound fair?
Even better, Lamb's first followers were people with weak wills and those with past traumas, like having lost people close to them. Porter is essentialy a prime candidate for her therapy, but rejects her easy way of getting over it.
"Meltzer's Choice", in its own sad way. Mark Meltzer has been captured by Lamb, and she starts giving her usual "ask yourself" spiel to convince him to either be turned into a Big Daddy or be executed. His response?
Meltzer:*dark laugh* ...I wasn't the first to find Rapture, you crazy bitch. And I won't be the last. You do ... whatever you want to me... as long as I'm with Cindy... I'm ... I'm a happy man.
The flooding of Siren Alley. There's nothing quite as exciting as outrunning an entire flood as pipes burst around you and the place practically falls apart. Probably one of the best moments of 2.
Eleanor Lamb gets one when you learn the full scope of the intricate plan she set up behind her mother's back to resurrect the years-dead Subject Delta (you) and lead him/you to her. And of course, she gets a minor one every time you use the above-mentioned Summon Eleanor Plasmid to call her to the field and watch her wreak utter havoc against your now-very-outmatched enemies. Lastly, in some of the endings, watching her, in the final cutscene, slay her mother.
The ever popular scene concerning the Unstable Teleport Plasmid; this plasmid is completely bonkers. It starts to teleport randomly about the area every time you try to grab it, until it finally settles down, then starts hovering and starts teleporting Delta around as well. This includes a shot of the plasmid chasing down a Splicer. Who. Is. TERRIFIED. FOR. LIFE. Yes, in this game, even a random joke item gets a CMOA.
Destructive Learning, especially considering what Delta has just been through:
Eleanor: Hello, mother. As you've always said, I shouldn't be allowed to wander the city in my condition, but without going outside, it's harder to hear much about the world, so I'm learning at home! This, I think, is a... porcelain tea service, in the style of Louis the 15th, isn't that right? (sound of a crash) Now that's a fascinating sound! And this is called a 'stained glass window,' hand-crafted by your adoring flock ... they've gone to a lot of trouble to capture your likeness, haven't they? (sound of shattering glass)