Joel...
I'm almost lock step with you regarding Bandon Trails.
Tobacco Road elates and deflates me. Some of the most epic holes of all time are on the course and some really weird ones too.
Black Diamond Ranch Quarry course.
Fishers Island...perhaps the most ecstatically good run of holes I've ever played, 3-5 (or 6 or 7)...and then some eh holes...then some WOW holes...and some eh.
Royal New Kent...again, like Tobacco Road, some crazy good holes...and moments of WTF?!?