Hi Zoabe,
Me and my wife have been house hacking a duplex in Greater East End (Magnolia Park) for about 1 year.
Financially, it’s one of the best decisions we have ever made. That said, we had to purchase a fixer upper to meet the 1% rule. Labor and materials were about $15,000 total to make the quality comprable to our previous house in Washington Heights. It was pretty stressful managing contractors while working on the house myself too. After about 3 months, all the big projects were completed and it was much less hectic. Since then, it has required no more effort than renting.
We were lucky to inherit great tenants from the previous owner. We decided to renew their current lease even though it was $200 less than market rent for the area. It has been well worth it. They keep the house very clean, do all the yard work, make repairs for free, and even cook dinner for us every other week. Never had a single problem.
If you are thinking about raising children I would recommend Heights, Washington Heights, Rice U, Rice Military, or Montrose. Heights is best bang for your buck IMO because you can still find a duplex or SFR+ garage apt. for around 400k. Other areas mentioned easily start around 600k - 700k for the same. Schools in the Heights are improving every year, so it is ideal for younger couples.
Feel free to message me if you have more questions and good luck!