As for par order, I have never seen anything which approaches the oddity at Bishop Auckland:
Out: 4, 5, 5, 5, 3, 4, 3, 3, 5 = 37
Back: 3, 5, 3, 4, 4, 4, 4, 4, 4 = 35
Doonbeg, which Ol' Man Yates cites, is quite odd, but I enjoyed it and think it works nicely.
To answer the question, I think a designer's brilliance comes out whenever the routing fits the terrain and makes for good golf. While it matters how the par and length unfolds, those are only two of the aspects which make up a fun and interesting design. It is the flow of the notes that make for good golf music...pace, rhythm and the element of surprise.