Kingsmill is very nice and had free bus transport to Colonial Williamsburg and Busch Gardens. Ford's Colony is a little further out (maybe 8-10 miles from Williamsburg) but equally beautiful.
Both offer an extensive list of ameneties including golf courses, spas, pools, marina, etc. Of the two I prefer Kingsmill because of the convenience factor--and I adore their running trail.