@FTEngineerM
I have been where you are and I will try to give you the benefit of my experience FWIW now that my LO is 21.
Work was always important to me, I always wanted my own financial independence and always needed more than just being a SAHM (in reality I could not afford to give up work fully but that wasn't my driving force.
My DS went to a private CM who actually treated him like a grandson so that helped and made me comfortable but in all honesty it was a cheaper option than a nursery 20 years ago.
Looking back now for my career it was absolutely the right choice, I am not loaded but am financially comfortable enough and part own the company I started at when he was 9 mnths old. I still love my role and the company and can't imagine not being there, they are sort of like a separate family to me in some ways.
For my DS, I do honestly have some regrets, I regret not taking enough time out with him and being there for him at all his school events (the company wasn't very progressive but is now), missing assemblies, coffee mornings, not having play dates and him not being able to come home after school and just chill but me picking him up from chidminders after work and coming home rushing tea, homework etc.
I think unless you have grown up children then its difficult to understand that those lost moments you won't get back. I think if you work full time and you have DC's you are in danger of constantly feeling like there is not enough of you to go around or your not quite giving enough at work or home because it is hard and you do have to negotiate what time you can give to both.
Interesting enough though when I talk to my DS about it and any regrets I may have, he actually feels very differently about it. He feels that I set a good example of how if you work you will achieve, be it holidays, promotion etc. He doesn't see it as time lost because he never knew me as a SAHM so didn't have a comparison. He had friends in childminders/nursery and after school clubs so didn't get what I meant about the playdates thing. He feels that he had a happy childhood and I was there when it counted and he always knows I love him.
I have friends who chose to be SAHM and some regret it and the position it has put them in and I know some who have loved it and wouldn't have it any other way. I know people like me who chose to go back to work and those that didn't have the choice and again it is an even split of those who feel they should have stayed at home more and those that feel that it would have been far more damaging to their DC if they had because they would have had low self esteem or poor mental health if stuck at home all day without getting a break.
I think there are no right or wrong I think you have to do what you have to do either for financial reasons or for your own self worth and that is different for everyone.
Telling women or parents generally that their children will be damaged or they are neglecting them if they return to work is awful because what is that telling those who have no choice?
Only you know how you are feeling and what is right for your family and the decision has to be yours.