I like the so-called Ross easy opening hole but if not that then at least an opening hole with a tee shot that's long and absent of serious trouble like water hazards, OB or trees making the fairway narrow. Basically any hole where I can go ahead and make a full swing with a driver rather than having to fit a first tee shot of the day into a difficult target of some kind. I think medium to long Par 4's are just the ticket.
I don't like the cliche of saving three of the four toughest holes on the course for the end of the round. That said, I think there's something to be said for a memorable killer hole somewhere late in the day just so the anticipation is there throughout the round. The seventeenth at Sawgrass is the example that first comes to mind. My home course has a longish, uphill Par 3 to a small, sloping green with a semi-blind tee shot for its seventeenth hole and it's interesting how often that hole comes up in conversation along about the middle of the back nine, especially in a tight match.
One thought I have about sequencing is this. If you have two or three "easy" or "birdie" holes out of eighteen then spread them throughout the course, don't use them all early in the round or put them all on the same nine. In a way, holes that you expect to do well on provide their own kind of pressure. There's nothing more deflating than to be struggling a bit late in the round and come to an easy Par 3 or short Par 5 along about fourteen or fifteen thinking that's your chance to get back on track with a birdie or tap-in par and instead you make yet another bogey (or worse). I think any opportunity to get the player's emotions going up and down repeatedly adds a challenge to the course.
Thinking about the much-discussed tough Par 5 fourteenth at Cuscowilla, that would be a waste if used as the front-nine Par 5 rather than the back-nine one. If you faced it as the second hole of the round (rather than a fairly easy shorter downhill potentially reachable one) it would sort of set the mood for the whole round rather than being a speed bump on the way to the excellent fifteenth and seventeenth where most matches will be decided.