So, a basic transfer switch beats running extension cords. You have to figure out how many circuits you need to energize and get an appropriate switch. Auto transfer is nice, but unless you are away from home for days at a time or live where outages are common, not really necessary. If you have natural gas available, a Generac or similar is really nice. Dragging out a generator all the time gets old. To size the generator, you need to figure out the loads. Well pumps can be power hogs.
I ended up with a good 5k generator because the people who bought it were trying to run a whole house plus 5 window AC units at the same time and kept overloading the generator, so they said the generator was junk and gave it to me as scrap. Nothing wrong with it, they were just being unrealistic. My parents have a 5k generator that runs the well pump and water filtration system, two fridges and a freezer, plus a couple other little things and a microwave. Everything can’t be running at the same time as far as the big things, but out of the 6 major things, 5 can run at once. All 6 and the generator struggles a bit. The house is super insulated with huge windows so heating and cooling are kind of non-issues though.