Some thing are a complete no, no...
- Par 3s
- Carry over water
- Drivable Par 4s
All of these lead to unnecessary delays to being the round.
I'd prefer one of two types of opening hole. Either a shorter Par 4 that has some outside "character" which gets you into the mood of the course, or a moderately reachable Par 5 that requires thought and challenge on the 2nd shot.
The first holes at Pinehurst and Prestwick fit that first model. Either could be played with an iron or fairwood off the tee, and not only do they offer a glimse into the character of the course (ie. the pushed up green at Pinehurst or the narrow fairway and gorse at Prestwick), but there is nothing that speaks to those course more than hearing the church bells from Pinehurst Village or seeing the starkness of the railroad tracks at Prestwick.
The 1st at my home club, Raleigh CC, offers a great example of a Ross 1st hole. It's 515 from the tips and plays slightly downhill. The tee-shot is fairly open, but the long hitters are constrained by a small pond at about 300yds (but downhill, so reachable). The second shot could be a simple lay-up or you can go for the green, but those going for the green are faced with a 2-3 iron, from a downhill / sidehill lie....early in the round. A duff is in the pond, a slide is in the trees or potentially OB, but a well played shot can run onto the green. For those that lay back, the approach (60-100yds) is to a narrow, Pinehurst-like undulating green that slope back to front, but falls off hard to the back. So you're faced with an accurate approach early in the round.
There is also something compelling about a 1st tee on a course that doesn't have a practice area (ie. Prestwick, Royal County Down).