I gather that "Bumfuck XX" is the approved term for a region within XX state that is a bit out of the way and I heartily approve of that.
If you live in Bumfuck AQ (for example) you might have local issues that you might think are better served with a local rather than state or federal approach.
Some of your states are quite large. For example TX is nearly three times the land area of the UK which manages to cram three separate nations within its islands, one of which is minority shared with Ireland and the rest is even more complicated!
If you are happy with big govt then all is fine. That is what you'll get if you try to remove the old ... glue. Those old sub divisions are communities ie groups of people who are effectively the civic or regional version of families.
I suggest you strive to keep those webs of community together rather than try to tear them apart in the name of administrative efficiency or you will discover what bumfucked really means.
There is value in local control - with some glaring exception.
Local control is desirable, the question is the proper granularity of local control in the modern era. The structure of places like the Bay Area with dozens of little towns that have veto power over everything is too granular. Planning should happen at the granularity of entire metro areas.
Some towns for example have laws against leaf blowers in a state where leaf blowers are unregulated. Some towns ban certain dog breeds.
I liked the government structure of the ACT when I lived there with a territory government that also had all the local government responsibilities for bins etc.