They made the fairways so that they're lush in middle and brown on the sides. In other words, if you hit your drive in the middle of the fairway, it's not going to roll out, but if you hit it close to the edges, it's going to bounce into the shit. Should make things interesting.
Sandy courses drain well, but they also are generally more consistent in their bounces because they are softer than courses with more dirt base. Sand isn't cohesive so it doesn't get really hard when it dries out. You really need to have a clayish layer, where the particles cling together when they dry out for it to get hard. So I would say it wont be as dramatic as you think.