Mapping and Geolocation

Hey all. I've been doing a bunch of research on mapping tools in Drupal. There seem to be a lot of options and I"m trying to come with the best solution and the best solution that would go with the future of Drupal. My goal is to make things really easy to geolocate to areas of towns and what not on a map. From what I've seen with other developments in a node I'd want to use CCK to do a lot of the mapping.

I'm thinking of using CCK fields for Lat/Lng, Address, City, State and Zip. This way I have any data added to the node we might need for mapping. Would these be the best and then how do we integrate into a mapping module. I've seen OpenLayers, GMaps and others but I'm trying to see what would be the best for at least plotting on location or area that the node is referencing.

I hope that makes sense. Basically I'm just trying to go through all the options available and figure out what is the best for mapping on nodes using CCK.