For parents who want to take their kids to a sporting event but are worried about drunken a-holes, baseball games tend to be incredibly family friendly. Some fans will knock back a couple brews during the game, but I don't think I can remember any more than a couple drunken encounters.
If you live in Buffalo you can check out the Bisons, or Toronto and Cleveland are a virtual stone's throw if you're not interested in the minor leagues. I've taken my niece and nephew (6 and 8) up to the SkyDome (excuse me, "Rogers Centre") a few times and also The Jake (excuse me, "Progressive Field") and they love it! You can't beat the atmosphere of a ball game, IMO.