The holy grail that you ask for isn't available. Lots of people claim it, but I haven't seen it.
So to answer the question...
"What do I need to look at to cut through all of this?"
A miracle!
You can get close with a Smartphone and an online backup service.
I don't know of any sync products that let you sync certain contacts only though.
