Ben,
If I remember right, the trip is at least a couple hours between Carnoustie and Berwick. Berwick is a must play if you can fit it in. If you are flying early on sunday, I'd head closer to the airport on Saturday night. If you are flying late, it really doesn't matter.
Have a good trip,
Greg