Honestly, the bigger use case is organization of devices. Trying to find the balance between locations and devices types. The only down side with geography-based locations in SNMP is naming conventions. For example, we have dozens of devices spread around the same city (and cities) so simply putting in the city/state doesn't work, we need the full address. Putting a legit address in an snmp location for the map to work is acceptable, but we had historically put in our own naming location conventions (ie phx-r1, iad-sw1) etc, similar to CLLI codes.
Since we're still trying to find the right balance in the location (and yes, I know you can customize/overwrite them, but I'm with you, automation is your friend) and device type, we went down the path of organizing, for instances, switches into core, distribution, and access switch device types. Having fast access to all of our core switches and different DC's for example would be a very convenient view for us. Such as being able to drill down into all of the access switches within one location.
Just thinking out loud, looking for how others are organizing this. Automation rocks, but it is only as good as the data you're putting in.