Sam: coming from tent camping I've always had a distain for generators, but having moved up to a pod, I got a quiet little Yamaha generator. They are noisy (not as noisy as most, but loud when you're sitting outside eating, or whatever). You get used to it though. And in many cases tent campers and trailer campers aren't too close together. Even if they are, if it's not you, someone else's generator is probably going to be running within earshot.
If it's just you you're concerned about bothering, you don't have to run it all the time. Most campgrounds have quiet hours so you can't run it overnight. It is nice to be able to crank up the microwave and/or recharge the battery if you're in the same place without power for a few days.
And it depends a lot on where you camp. Wind, water, natural barriers like trees or dunes do a lot to dampen the noise quickly over fairly short distances.
That said, some generators are a lot louder than others. I thought it was worth it to buy one of the quieter ones.
TT