I must agree with A.G. about #9 at Caledonia; I find it to be a very good hole in its own right, and I don't mind that it finishes the front nine because it gives any player a birdie chance that could likely help them post a number (whether it be breaking par, 40, 45, 50, etc.).
I also think that a bit too much is made of #9 being disconnected from the rest of the course. The walk from #8 green, while longish, is very pleasant. You stroll by the chipping greens and under the shade of Spanish-moss-laden oaks, all the while licking your chops at the prospect of making a 2 on #9. Not only that, but seeing cars driving in along the drive makes one smile, wondering whether the driver of the car knows what's in store for him/her. In fact, I was considering discussing it in Mark Bourgeois' recent thread about longer green-to-next-tee walks, but declined in the end.
If anything, the 1st hole is more isolated because it's across the driveway. What's more, it's quite a bit longer-disance from the bag drop to the first tee than from the 8th green to the 9th tee or the 9th green to the 10th tee, I believe.