A short note, since you're staying a while
One of the more curious things I've noticed is that nobody sets out to build a confusing system. A tool gets bought because a team was stuck. A field gets added because a report needed it. A review step shows up because something went wrong last spring. Each choice is reasonable on its own, and the sum of them is a place where nobody can find the current version of anything.
That's not a criticism of anyone. It's what reasonable people do when they solve the problem in front of them. The work I like is standing far enough back to see the whole thing, then making it simpler for the people inside it without telling any of them they were wrong.
I live in Minneapolis. I'm a dad, a golfer, and still, happily, a student of all this.