One other option is to house hack a SFH with a carriage house or a basement that has a separate entrance of some kind. 

…a lot of these issues depend on the size and layout of the house—for instance, if the housemate who gets home at 2 am has their own private entrance, and they can get into the house without disturbing anyone, then it may not be a problem.Moderately important: Have at least one “premium” option in the house.

If you don't like the idea of roommates, then a home with a separate entrance to the basement allows you to Airbnb or short-term rent a space. 

Will the attic units have windows and exterior entrances?

@Chandirasekarendiran AnandanYeah, I know this is not always true, but if I see one partner not being on board with house-hacking, it's usually the woman, for obvious safety reasons.What do you think about a home with a basement that has a separate entrance?

Pex Piping , Slab foundation, no slider or door for rear access from inside the house (have to add a side gate entrance to the rear) No garage, No Dining room (possibly could put a small table but the island would be a better idea)What's wrong with Pex?

I had one bad instance early on, but AirBnB paid me out on it, but have been clear in my messaging...have ring cameras at all entrances (and make sure this is clear in the listing) and then let my guests enjoy themselves. 

You can make a "landing zone in the entrance that is wood or carpet or cork with a transition to the tile if it is that much of a concern. 

It has two separate entrances with an extra 100 sqft of storage behind each garage. 

The Barn (the front part) already has a  400 sqft loft, a space for a Kitchenette and a bathroom and its own separate front entrance. 2.