Check out this British sourced post giving out a pretty complete state of the LBS panorama. It does shoot at everyone with reason and tons of wit, sparing the Intel/PlaceLab/Wigle combination.
Interestingly enough, Directions Magazine has a PR from a major implementation of what looks like a pretty useful service.
Let's say a:
"family relocating from Germany to a base in Oklahoma can search for installations related and local services in the area including schools, ATM’s, Pharmacies, parks and other municipal services."
Developed by eSpatial which provides OGC Web Services, it includes an Ajax interface and uses "NAVTEQ’s Streets and Points of Interest (POI) dataset". Oracle databases are "used for geocoding and routing."