Found my wife and got married during the pandemic, have a 4-month old now and working from home 3x a week gives me the chance to see her grow. I would not be as happy if I had to commute everyday to work, even though i'm more of an extrovert and like to hang out with others. Being at home more also means I get to do more house chores. But the joy of seeing my baby grow is incredible!
Yes, if you are at the office 24 hours a day like Elon it's likely you'll do incredible things, but to me it's worth sacrificing some of that success in exchange for a family life.