Melissa, nearly every "just a housepet" BC I know has behavioral issues. I would never go as far as to say that all Border Collies *need* herding, agility, obedience, SAR, etc. in their lives, but it seems that most BCs don't like being completely "unemployed" and behavior issues pop up out of that boredom since they assign themselves a job. Usually this does involve aggression or obsessive/hyperactive behavior. But you need to realize that these are dogs bred to work, not to sit around all day and sleep. So if you don't want them picking up household "chores" like guarding, pestering the kids or other dogs, or trying to exercise themselves indoors, just do yourself a favor and don't get a BC if you can't provide it with adequate exercise or something to do! (general you, Melissa, I'm not singling you out. I just don't have the patience to write a less personal sounding post.)
Not everyone knows how or wants to train a BC either, they are dogs that need a lot of training and that rarely come "pre-programmed" as a good house pet like most of the companion breeds.