Certainly the most memorable experience in a kayak was a couple of years ago when I suddenly found myself in the midst of about a hundred monster sea lions that didn't act like they were too happy to see me.
I've had a few times when the water conditions got kind of daunting, but the kayak has always turned out to be more confident than the paddler.