Don't count out a home with one larger room, that you can add an exterior entrance to (cut in a door where a window is at present) and create a studio with kitchenette.
Hubby and I are currently doing this very thing. We bought a small farm near Coeur d'Alene, Idaho. The farm came with a 2 bedroom apartment in the shop. This is very common in this area -- people buy property and build a shop with an apartment. They live in the apartment until they can afford to build a bigger house.
This is the ideal set up for an Airbnb. We get the advantage of renting out a "whole space" but are still onsite to prevent parties, vandalism, etc. We cater to families who want a "farm experience" for their kids (collecting eggs, playing with our goats).
Ben Leybovich calls this Luxury House Hacking. It sounds like a wonderful way to go even if it’s not likely to be as lucrative as hacking a plex. Check out his article on this great strategy: https://www.biggerpockets.com/renewsblog/luxury-house-hacking/
This can certainly work, just make sure to check that the subdivision or area where the home is located allows short-term rentals. Here, on the Panhandle, STRs and VRs are all over the place along the beach, but a lot of residential areas specifically forbid them both through zoning and also various restrictive private covenants.
Wow thanks for all the feedback everyone! Certainly a ton to think about, glad to know it's been done before. I've seen these postings on Airbnb, so I just wanted to know if anyone had any experience and appreciate all the awesome feedback!