I've studied redistricting and gerrymandering for 15+ years ( https://bdistricting.com ), and yes the punch line is that people don't even want geographic districts at least half the time. Sometimes you want 'your local rep' to talk to about local and regional issues, but all the argument is about ideological representation (party, culture, pet issue, etc.).
My best guess solution is a two part legislature, one house of small local districts, one house elected in at-large Proportional Representation.