As far as par 5's, Scott B.'s home course Wake Forest G.C., has a lengthy opener -- 711 yards. Nothing like taking that one on out of the car cold. To make it even tougher, there is a creek cutting across the fairway about 180-200 yards from the green. The last 170 yards or so are straight up hill.
Yep, that's my longest par 5 played, hundreds of times.
2nd longest yardage-wise is #18 at Kapalua (Plantation) at 663 yards, played just 3 days ago, but it's a ski slope downhill, not playing nearly as long as #9 at Rolling Green mentioned by Wayne above. #1 at WFGC still plays longest of them all.
Longest par 4 yardage-wise is 501 yard 16th at Po'ipu Bay, home of the Grand Slam of Golf, played 4 days ago. It's downhill, downwind, so there are countless holes that have played longer than that one.
Longest par 3 was #4 at Barona at 260, but the back tees were closed when I played there. #13 at Nicklaus' Hokuli'a on the Big Island of HI is 258 form tips, 253 where I played from next tees up 11 days ago. Straight downhill, so still just a long iron. #12 at Dunes in Myrtle Beach from tips at 245 is a full 3-wood, but the longest-
playing par 3 is easily #10 at Rolling Green at 243 slightly uphill, also mentioned by Wayne above.