First off, Brucseki this was great a real treat to "walk" the course. I'd estimate you displayed about 350 pictures! Thanks!
Now the 18th. Prior to Ress renovation this was the weakest hole on the course. Now it's the wekaest hole the course. Actually, it's decent, but I can't get fired up over this hole. The terrain is awkward, and short of plowing over the 4th green of the Red, a nice par three, I'm not sure what could have been done with the tee, short of some major earth moving.
Tee shot is the straightest on the course and not easy, but the prudent player will take the pinched landing area out play by hitting a 3 wood or long iron. What I would have preferred is a for the two bunker complexes to be more diagonal, consistent with the bunkering elsewhere. Positioning the two clusters in a way to make the player think about the tee shot. Now you've got something.
I sort of like the green complex, not overwhelmed by it. There will be some difficult hole locations. I do think there is some decent tilt from back right to front left and with very firm and fast conditions, there could be some interesting putts. The bunkers are very deep and short siding the back right hole location is not good.
I will say this about 18, it will give someone an opportunity to make a birdie, but also the leader to make a bogey. Given the difficulty of 15-16-17, I'm not sure another very difficult hole is what the course needs.
This will provide a very good ampitheater effect that will be neat to see.
What else could have been done to the 18th, or better said, differently? They could have moved the green up the hill some more, making it more like 435, but you lose the spectating area. The rear bunkers, thankfully were removed, completely out of place and of little use. I recall hearing that there was a plan to put a tee between the 17th tee and 1st green and play it as dogleg left, that might have been interesting, but would have made the area a bit too congested and tee shots might be dangerously close to those playing the 1st hole. If you can look at the AOTD for the Black you might be able to see the logistics for such a tee.
My own personal idea would be to clear out the trees to the right of the green and move the green complex back about 20 yards and slightly (so as not to interfere with the 1st on the Red) to the right (see the 2nd picture). Then the countours of the hill could be better used, rather than just pushing the green up against it. Also, the bunkers to the left of the fairway, could be more diagonal and make the player think about trying to fly the right bunkers as you would probably run the fairway around the right cluster. I think this could make for a very interesting hole.