You can now toggle between "Geographic" location data and "User location" data in the Google Ads connector.
The connector by default fetches "Geographic" location data, which uses the viewer's physical location or locations they have shown interest in via search/Google Maps/etc. If you check the Enable user location view in the connector options, location data coming from the Geo Performance Report will instead be just the viewer's physical location.
Note that this setting only affects data from the Geo Performance Report specifically, which is where the majority of the location data is requested from (city, country, region, etc.)
Setting in Google Sheets:
Setting in Data Studio:
Setting in Excel:
Add custom option with text GEO_VIEW.