We have three Pits and an American Rottweiler. None of them are even slightly aggressive or we wouldn't have them. We have two small children in the house and two cats. The dogs are quite protective of the kids (in a good way) - in old England, pit bulls were known as the Nanny Dog, because they watched children when their parents were away.
Like any breed, Pits can be trained to be aggressive - their physical makeup makes them especially suited to the task, and like all terriers, once they're into something, they won't stop. However, if given love and trained to be good pets, they're great at that too.
OK, that was my plug for the breed. Now, back to cigars!