I’m weary of any “trend” fomented by modern culture.
They are inevitably negative, and harm the family.
That said, I would love to afford being a stay at home dad.
My husband is retired and is now a stay at home dad! He loves it! He wonders how he ever used to have time to drive to Houston every day 1.5 hours trip each way, and work 14 hours, six days a week! He loves it! But he did work about fifty years.
I think there's something to be said for children seeing (certainly) their fathers going off to a job in the morning.
Of course, if you're wealthy enough, perhaps you'd run some sort of business out of your home, maybe have a formal home office. Either way, I think it's important for children to see that their parent(s) are doing some kind of productive endeavor in making money and contributing to their household.