I did say Megaton so that covers everyone in Megaton. But yeah I see your point there are some individuals and some small factions with positive views. But the over all population is still against it. Megaton I would figure treat Gob more as a novelty then anything else but that is just my view.
In the end though it is easy to see why people mistrust even hate ghouls. It is human nature to fear the unknown and blame others for bad things. The reason why humans came up with creatures such as werewolves in the first place was because it was a way to explain murders. People couldn't live with the idea that they would be living with a serial killer so they would blame it on a monster. A creature that lives apart from them. People blamed witches and vampires for everything from crops dying to a rat infestation.
In a world like Fallout where people live in close knit communities and something goes wrong, it is far easier to blame a monster than your neighbors or your own lack of education. And when you have actual mosters like ghouls around... well it just makes it easier.
The NCR got over ghoul hatred because they expanded and took over ghoul settlements. So yeah it was easier for people to see that ghouls aren't boogeymen. They aren't the creatures their parents used to scare them out of travelling to far from home. "Don't go out at night or the ghouls will get you." Type deal.
Humans will always have a monster to fear aka an escape goat. Whether it is another group of humans or something completely made up like a Vampire.