Dan,
i played Wexford last month and enjoyed it. as everyone has mentioned (and ironically posted on the club's website
) the greens are something else. i thought the 18th was a bit of a blah finish, even though it's right off the water, and didn't realized the fairway ended on the 11th hole and brought the water into play.. but i'm picky sometimes. people don't like the 15th green and the pond that fronts it, but it is unique.
CR is right off the island. of the row of clubs on the north side of the access highway it is no more than 15 minutes off so it's not like you can ride your bike if you're on island.. but again it's about choice. i played the dye course and loved it. one strong hole after another. i was supposed to play the nicklaus cse the day before that but my flight wouldn't land so i can't offer any insight there.
as Bill mentions CCC is a fabulous place, but know you are talking a bit of a drive. lots of fun and there are some stretches that make you open up your eyes and grab your attention. but if you are living on the island i'd probably find something closer.