I've found that Harris-Teeter ends up typically having better prices with their VIC/EVIC stuff, but at regular prices, they are all kinda similar. And the Publix stores I've been to all seem to be right next to a Harris Teeter. They are right across the street off 1010 and Kildare Farm road. The one on Leesville Road right by 540, there's a Publix and HT right next to each other as well. The one on High House and Davis Drive has a HT right across Davis Drive.
I rarely shop at Publix or even Lowes these days. I live near Brier Creek now and we usually shop Walmart, Aldi, or Lidl (if we are up that way, but one is supposedly coming to Brier Creek behind the Harris Teeter), for most stuff. Then the Harris Teeter nearby for stuff I can't get at one of those places.
As for the poster's original question, there are lots of places you can live, but since moving up to the Brier Creek area, I think it's ideal (the general area that
@garnetpalmetto described a few posts up). Easy access to nearby stores, restaurants, area breweries, etc.. 15 min. drive (or less) to the airport. Easy access to 40, 85 (north), 147(885), and 540 to get to where you want to go. Can be in downtown Durham in 15 min., but still only about 30 min. to get to downtown Raleigh. Lots of nature areas very close by (Eno river trails, Umstead State Park, Lake Crabtree, Falls Lake), etc..
The drawbacks vs. living down near Holly Springs area (I used to live down that way) are: 1) More traffic in Brier Creek area. 2) More crime vs. down there, but not terrible. 3) The roads / infrastructure is struggling to keep up with all the population growth, but that's happening down towards Holly Springs/Apex as well. 4) If you want more land with your home, there are typically more options down the Holly Springs way. 5) depending which neighborhood, you can be in the flight path as GP stated. Thankfully our house isn't normally in the flight path, but no guarantees that will always be the case.