The first hole that comes to mind probably isn't actually the best for me, but it has one of my favorite memories. Hole 12 at Turner in Arlington is a short hole that is fairly technical. It follows a winding creek up to the basket. The creek completely circles the basket, leaving it on an island that you are shooting at. There are several trees that litter the fairway on the way as well, making it easy to get your disc knocked off course and into the creek. One of my first times playing the hole, my wife hit one of said trees, and her disc ricocheted over by a large dead hollow tree on the left side. When she got to her disc I hear her scream, and turn to see her falling backwards as a large duck comes flying out of the hollow trunk right above her head. We couldn't stop laughing about it the rest of the day, and from then on that hole has always been the "duck hole" to me.
Probably the most fun I've had though on a single throw was at Bogus Basin in Idaho. I don't remember the hole number, but it was over 600' down the side of a mountain. There were a lot of trees, and being a mountain course, a lot of high brush with a pretty narrow clear fairway. Throwing my disc out there and watching it really take off, then out of view around a corner of the mountain, before it came back into view a few seconds later, was pretty exhilarating. I landed in the rough, probably a good 100' from the basket, but I was parallel to it, and even off a mountain, throwing a disc over 600' is a really fun thing to do.
My best at my home course is hole 12 at Bear Creek. It's also not very long, probably 220', but again, pretty technical. You can't see the basket from the tee, and have to throw it either FH, or RHBH on a good anny. The hole has a small creek running between the tee and basket, with a much deeper creek on the other side if you overthrow. The creek is probably 20' down a steep slope from where the basket sits, and all along the cliffside is guarded by trees of various size. More often than not I see people looking for their disc along the creek bed than I see them up near the basket, but when you hit the right line and sneak by those trees, you're going to be parked right under the basket. I always start Bear Creek on hole 13 and finish my game with 12. Finishing with that great technical shot and parking for a birdie is what makes it my favorite hole of that course and my favorite that I play most often.