I've definitely spent more time designing "the perfect system" than using it. There's a seductive comfort in planning that real execution just doesn't offer because actual work has feedback, friction, failure
The "architecture astronaut" syndrome is particularly endemic in software - we design elegant systems in our heads that would take 10x the time to build than a simple solution that actually ships.