My dad went the other route - he had an MIT Ph.D in nuclear chemistry and gave up his career to be a dad. He was always, always there to play LEGO with me or take me to the playground or drive me around to after school activities. And I really, really appreciated that - I probably appreciate it more now that I'm grown and he's dead.
The thing is - he still had something to prove, and because he had given up his professional life for me, he transferred that need to prove something onto me. And so for most of my childhood, I felt like I had to do well in school, and when I grew up it was up to me to win that Nobel Prize that he never had a shot at. And it went like that until I was in around middle school, at which point I basically said "Fuck that shit" and started sabotaging myself just to prove to everyone that I wasn't this super-genius who was destined to change the world.
And that wasn't really fair to me either.
I don't think it's really a matter of outcomes, of affording the big mansion in a gated community. I think that every kid deserves to have a dad who can be proud of who he is and what he's accomplished in life. If you can honestly feel that you're not giving up anything to be with your kids, but rather gaining something, then you should do it. But if you would otherwise be bitter and resentful for what you couldn't accomplish in life - it's better to have an absent dad than a bitter one.