I've always thought it would be interesting to be the guy called in to clean up these messes. That's where I'd love my career to go... being called in to turn around a sinking ship.
Technology projects have a habit of going wildly off the rails, especially if you're not at ${bigTechCo} with a really mature software factory pumping out large projects consistently, so it seems like there'd be no shortage of mess to clean up around the industry.
The idea of building something greenfield isn't as interesting as fixing a badly broken machine to me. Call it a fixer complex :)
Nah, it's a horrible job. They box you in so that there is no acceptable solution then blame you for not fixing it.