iPhone My Location
...www.sanoodi.com has beat Google and Apple to the punch, releasing a "My Location" app for the iPhone that seems to enable Cell Tower based positioning in Google Maps.
You have to be running native applications to get the functionality. Add www.sanoodi.com/iphone to your installer.app sources, and find the app under the Misc category.
Thanks to Wayne Sutton for the heads up.