@Elena C. congrats on getting ready to make the move, it's a big step! In terms of house hacking strategies, you are going to need find a balance that you are comfortable with from a few perspectives, including location, condition of the property, and bed count/cashflow.
From location perspective, Malden/Everet/Revere are all great areas that are changing by the day with all the development that is going on. Areas like Waltham are a bit different, and you could call them more "established". This will also impact the type of tenants you can expect, and if you are going to house-hack a single family and rent out a bedroom or two, you'll want to take that into consideration.
The other thing to consider is condition of the property. You talked about breaking even if the area appreciates over the next few years from the equity gain. Very true, though the other thing to consider is do you want to force appreciation through taking something that needs a bit more work and creating sweat equity though upgrading the home.
Finally, I would say take a look at the market for 2 families. Though getting a 2 fam in these areas in the low/mid 600s is not easy, its not impossible, and the cash flows there would certainly be a lot better. Especially if you going to hunt over the next few months in the winter when everything is a bit slower, there's a good chance with enough offers you could land one.
Good luck!