Some of my favourite holes are shorter par 3's with lots of trouble around the green. Requires touch and accuracy rather than bombing it close and hoping for a good lie. It's always really satisfying to be rolling birdie putts on those holes.
One of my very favourites is only 120yds slightly downhill. Water in front and left, sand right and long. Multiple tiers on the green. Depending on the wind for the day you could be hitting 2 clubs different. You really need to hit the right tier too or 3 putt is a likely result. Miss into the sand and you're looking at getting out hitting towards the water to a green that's running away from you! It's always exciting when we get to that hole - especially when there are multiple skins on the line!
Having said that I also like to stretch out on long par 4's too. I think a great course has a good mix of holes demanding length and also accuracy.