I tried the built-in ip address geocoding in the Rails plugin, GeoKit.

It's relatively accurate except for when the visitor is accessing the site from a corporate or school network, in which case it shows up where their main ISP hub is, which could be across the US. Unfortunately that's a large percentage of our users, so it just ended up confusing most of them. We had to remove that feature :(