The later stages of the firefighter profession have your sim pull one CMoA after another
The ghost hunter profession
The fact that Bigfoot is the supreme master of everything. Need somebody to do your gardening? Bigfoot! need a flower arrangement? Bigfoot. Need home repairs? Bigfoot! need a makeover? Bigfoot. Need a robot? Bigfoot!
The horse death animation. The Grim Reaper gets on the horse, strikes a pose, and rides off into a portal.
When a sim with "Brave" trait beats up the burglar.
Getting Pangu's Axe, without cheating. The scene itself is just amazing.