I would consider living in Cary. You will have great town services, access to all amenities and to Raleigh, and we enjoy some of the lowest town property taxes in Wake County.
You will find less expensive housing options in other towns, like Apex, Holly Springs, and Fuquay Varina, and with a slightly higher tax rate. Apex probably offers the most convenience among those three, with typically higher home prices than the other two.
Another alternative would be to be in an unincorporated area, living in Wake County. Wake County property taxes are only .678% of Assessed Valuation. At that, you will need to select a location that is not scheduled for annexation, but offers access to amenities you desire on modern highways. This could be a more rural option, however.