I have a much smaller generator for our camper. It's not fixed in the camper, it's portable enough to move around. We use the generator for power outages at our house every time there's an outage. Unfortunately, the output is only 110, so our well (220) is not functional. We do not tap into the house wiring, we just simply run 100 foot extension cords all over the house. We run one line for the freezer and refrigerator. We switch the line back and forth about ever hour on these two appliances. We run another line to keep the television, satellite, and internet going, which works OK provided the cell tower "down the way" has power as our internet is a line-of-site system, and not a cable or dial-up system. We run one line for the blower on the fireplace, and we run one line to keep a coffee-pot, or flat griddle working for cooking.
I've considered putting in a whole house generator, but the cost does not justify the few number of times we have power outages. Also, we have relatives in two different directions (5 miles one way, 10 miles the other way), we can always descend on in the event of emergency. And they can descend on us if they have emergencies too.
Of course, we also have the travel trailer we can use for heat, television, and sleeping if we want to. But we still need to keep the refrigerator and freezer going in the house too.
Your idea is not so far fetched. It's actually very reasonable. Work out the logistics and I'm sure you'll be most happy!
