This may or may not be my place, but if the order of maps in the rotation reflects the order they appear in, then some special attention probably needs to be given to how they're arranged. I mean, having GoldBowlWater all in a row followed by a string of 5CP and KOTH probably won't go over well.
That was probably a massive case of stating the obvious.
Speaking of GoldBowlWater, the core set, as I envision it:
Dustbowl
Gold Rush
Badwater
Gravelpit
Badlands
Granary
Viaduct
Viaduct will probably raise a few eyebrows, but I am not joking when I say that I cannot think of any regulars who simply do not like it. And I'm personally not too fond of Granary compared to other maps, but it's been in the rotation since forever and there are definitely worse maps out there.
Something that just came to mind: On some other servers I've been to, when a map change starts approaching, a vote automatically comes up for the next map. Although implementing it definitely "sounds suspiciously like work," it may be worth it to avoid potential issues with having to manually edit the rotation every few months.