Once I started and got past the imposter part of it all I went to startups, where they drained all my energy from myself and my family, just as you suggest.
Now I'm somewhere that requires very little of me technically, where I can work pretty much JUST 40 hours and get by and make everyone happy.
I still struggle with trying to make more out of it than I really need to.
I still struggle with wanting to do something totally different, way outside of computers. I feel like I've "conquered" this already. (I know, that's really shallow).
And, if you are engaging in one or another form of workaholism (until "someday", "it will pay off", to avoid the crazy/upsetting at home, etc.), ending this is priority number one.
The basis of your health is a good personal life, whatever that means for you.
For some people, it genuinely is their work. I don't mean to discount that. But if you're working for "someday", rather than loving the moment you are in, well then, make sure you get out of there at a decent hour and find some moments you do love.
But there is another aspect too, like if we can plan and buy some financial freedom we can pursue other creative fulfilling stuff.
I think this problem exists across ages unfortunately.
I currently have a car which shouldnt be difficult to let go.. after all its my inner freedom that i crave for.
I really like the approach of some companies which evaluate their tech stack and only transition to other technologies in a phased manner.
Don't look to your job for any kind of fulfillment or satisfaction, unless your job is your own company and you're doing something you're passionate about. Otherwise, be a complete mercenary and treat your job as nothing more than a way to keep the rent paid, the lights on, and food on the table. Then find ways to achieve fulfillment or whatever it is you're looking for, outside of work.
Maybe that means volunteering at a soup kitchen, maybe it means working on a startup as a side project, or maybe it means playing video games every hour you're not at work. Whatever, it's up to you. The point is, take control of finding whatever meaning it is you want to find in life, and don't let it be all commingled with your job.
Ultimately you may decide you don't even want a "normal job" at all. Maybe you will decide to freelance. Maybe you're meant to be an entrepreneur and run some kind of business, or possibly multiple businesses. Maybe you want to go all Tim Ferris "four hour work week" and move to Thailand or something. One thing that will help you maintain maximum flexibility is to avoid things like a mortgage payment, car payment, etc. If you already have those things then you'll have to deal with them, but if you don't, consider not buying a new car, or a house, etc. until you have things figured out. It'll be easier to up and move, or make other dramatic changes without those encumbrances.
Some people will say to choose startups over a big MNC, but I find that startups can be worse in many ways (again, unless it's your own startup). Work hours may be more demanding, there may be more stress, etc... OTOH, if you accept my position about being very mercenary towards work, you can often find a boring position at a stodgy large company, where you can "punch the clock" for pretty much exactly 40 hours a week, do relatively boring / undemanding work, get paid a decent salary, and - most importantly - reserve as much of your energy (mental, psychic, spiritual, or whatever you want to call it) for your own initiatives outside of work.