We have seen many Drupal sites with contrib GMaps modules added, but the most versatile solutions which suitable for specific needs is to create the custom modules by hand.

And they both work perfectly.
Yes, it is possible to achieve location based service with Google Maps and Drupal.

- Development by InfoPrima -