Absolutely, in a heartbeat. My world revolves around my DD and I loved being at home on maternity leave. It isn't "just being at home", there is so much to plan for them, aid their development and frankly I just love her company - she's one and just so engaging, there is never a moment of inactivity - we can draw, read, go for walks, swim, play music, you know there is so much to do, every simple task becomes so much fun, as well as a learning experience. And never in my life have I ever felt so fulfilled.
I have to work for the mortgage but don't really like what I do for a living - and I am a professional, the sort of real career people aspire to and get stuck into. But it doesn't really interest me anymore! I just have to keep going because I have to do the best by my family.
I think it depends on the individual, but I would give up work tomorrow. There are so many things you can do whilst being a SAHM, not just coffees and hoovering.
That said, I see as much as I possibly can of my DD and tbh I have SAHM friends who see less of their children than I do as they use nursery and babysitters to have a break. I work part time and keep my hours as strictly as I can, don't do a drop of housework until she is in bed every night. Barely sleep but have much more time with DD, so definitely worth it.