I did it.
I had a well paid career in finance (not mega mega bucks but higher rate taxpayer). I stopped working five years ago and have two small children.
I don't have any regrets. However I'm financially secure. I'm married, we own our house and are still able to overpay the mortgage and save (and we have savings in both of our names individually and jointly). We have no debt other than a mortgage. DH earns really well (far exceeding what I earned and since I stopped working he had almost 'made up' for the loss of my salary in his pay rises), we still pay into a pension for me and we have income protection insurance. So we don't have money worries and we bought a family sized home before we had them, so we don't need to worry about space or moving.
Totally get judged all of the time for 'living off of my DH' but tbh I've got a thick skin these days and I don't care what other people think. I've been able to be around to be with my children every day of their lives and I love that. They both went to preschool for their 15 hours when they turned 3 and were funded so they still got socialisation with other children and I took them to (ugh!) toddler groups too.
I will never go back to my old job. One, I'm out of date now, and would need to retrain to an extent anyway. Two because it was dull and I didn't enjoy it I only stuck at it because it paid well and meant I could save hard. Once both of mine are at school full time (only one is atm other one is still little) then I will probably do some part time work around their school hours but I'm in no rush.
There's been no real downside for me. I still see my friends, I'm not lonely, I have equal free time with my DH for doing my own thing. I volunteer a few hours a week which I enjoy.
It is hard when they're tiny especially if you have two who are both little. One of mine has additional needs and that made/makes things tough. Quite relentless in all honesty especially when they go through non sleeping stages, teething, illnesses etc. But I'm glad I've been able to do it all myself. DH is a great Dad, which helps because I've always been able to say 'take the baby, I'm off out for a couple of hours' at the weekends without worrying.
It's not for everyone! It depends on what you enjoy I think. There's nothing wrong with preferring to work either, some people find a better balance doing that. I definitely feel like I'm in the minority, in our friendship groups anyway.