Scenario 1: The over-achiever parent
I see this frequently, a parent that wants to be a super parent. This manifests in a bunch of different ways, but usually it's enrolling their kids to 15 different activities essentially running all over the place being glorified taxis for their kids.
Then their kids don't know how to function if there is nothing to do.
Scenario 2: The I'm missing our parent
Parents that either had kids too early, or not by choice. They feel like they missed out, so they lament about all the fun they didn't have. This is a weird form of resistance to reality. What usually happens is that they will get a divorce, to somehow escape their children. I am 40, so I see it with people my age, they divorce, see their kids 2-4 times a week and do crazy stuff to somehow recapture their youth.
In my opinion it's about keeping a good balance. If you never make time for yourself that's a mistake. If you put the bar too high as a parent you are bound to miss. The simplest approach is to carve out some time to yourself, balancing things out with your significant other. Enrolling your kids in 1-2 activities out of school and recognizing that not every single minute of a day needs to be hyper-optimized.