We have so many wonderful neighborhoods here, I'm sure we can find what you are looking for.
Besides having a great realtor who has lots of experience and has lived in the area at least 5 years, you would do well to go with a company like Fonville Morisey which is the leader in the Triangle area. We have in house lenders who are dedicated to residential mortgages, and who smooth the way to a successful, on time closing. They can also deliver a preapproval letter within 24 hours so you'll be ready to go once you find the perfect house. That's so important.
I'd love to help you find your home. It sounds like looking for a house I would love as well. Take a look at the reviews under my profile. You'll see my clients have really enjoyed working with me.
Here are 41 homes in Cary that meet many of your qualifications:
These are not my listings, but are the listings of many area agents.
An advantage of using a buyers agent, rather than the listing agent, is the agent will be motivated to help you find a home that fits you, rather than just selling one of their own listings.
It is very difficult to perform a search for homes with lots of light, very bright inside, and more feasible to perform a broader search and cull out the ones that do not appeal. Likewise with kitchen and bath updates.
I've attached a link below to what has proven to be the most popular blog I've ever posted on how to find a great buyer broker. I am a local agent, you may check me out here on Trulia or simply Google my name and I'd be happy to assist you. I specialize in buyer side brokering, it costs you nothing. Feel free to contact me directly.
You given a good detailed explanation of what you're looking for however no one can start sending you listings without a direct email. You're going to have to respond to an agent directly and so that they have your email address in order to start receiving listings.