Just came across this soccer stadium at Kennesaw State University, and it's size / scope would be perfect for Cavalry FC down the line, should they (and the CPL) prove to be a successful franchise a decade from now:
The public concourse, atmosphere and urban integration are top notch, IMO.