My mom has a Border Collie and she is super smart and a really good all-around dog. She does have a high energy level, of course, and loves to run and play. She is very focused on my mom, which makes obedience and agility classes really fun for both of them. I think one of the main things to keep in mind with a BC, in general, is that they need both physical and mental exercise or else they can get bored. Rally-O, agility, obedience, etc. can help with engaging their minds.
My mom takes her BC for daily exercise, sometimes just a walk around the neighborhood and other times a good romp in the woods. I must say that I have never seen her BC actually tired out no matter what she's done, but I will also say that she is a really great dog and has never given my mom any problems. I also remember that my mom was a little freaked out with all of the negative stuff out there about the breed, but she has had a really wonderful and positive experience with her BC. Enjoy!