WaterBoyz,
As I understand it, there will be a switch replacing the "Main Principal" switch, which will change the power source between the utility and the generator. The existing panel door will close over it and look the same as it currently does. There will be no separate panel. I am assuming I will switch off all the breakers, throw the switch to generator power, plug in and turn on the generator and start loading it by turning on the breakers I want. Of course, I won't be able to run everything at the same time, but everything will be theoretically available (I think the heat pump and furnace would overload it, but we have a wood stove.).
So, it's not automatic like the full house backups, as I understand how they work. I'll post a picture after it's installed by the electrician.
I live in the country, so the noise is not a factor to us or our neighbors. In fact, we were jealous when we heard on humming during the recent outage.