A lot of things can be memorable.
Cards that produces tense games: Dark Confidant, Demonic Pact, Angel of Grace, Triskadekaphobia.
Cards that produce miserable games: Jokulhaups, Smokestack, The Abyss.
Cards that have high variance: Also Dark Confidant, Bloodbraid Elf, Gyruda, Doom of Depths...