I'm looking for a maintained module that allows to add a geo location to a node of a custom content type. I am looking for something that has integration with Google Map API so that it's possible to query the location using an address, ZIP, or name.
If you are not a fan of Location and Gmap you can try out Gmaps or Open Layers. I am personally not a fan of the Location module and find it bloated and unintuitive. Open Layers has a number of modules that extend it's functionality. Plus it was developed by Development Seed so you know it's good.
The advantage of openlayers is that you are not tight to one particular map provider, but you can switch just by changing your options.
You can set geofield to take the value of the address field, geocode it and store the lon/lat value of the address. You can then draw the locations on the map. The geofield works with google or yahoo for geocoding.