I took a few pit mixes out of the local humane society last summer for "Doggy Day Out", basically an opportunity for dogs who need new homes to get exposure to the community and get away from the kennel for a few hours, and they were universally friendly, sweet dogs.
There's some selection bias, obviously, but their reputation is definitely overblown.