Most Border collies in shelters do come from backyard breeders, but because the breed has only been widely available in the US for maybe twenty years, the bloodlines are still pretty healthy and temperamentally sound. Most of the shelter BCs have just been turned in because they were, well, BCs.
It might be instructive to relate what motivates someone to abandon a perfectly normal Border collie. Most BCs are VERY close to their working roots. When we say, they need a job, we really mean it. Most people who are successful at having BCs for companions put a lot of work into it, or they have a lot of time to interact with their dog.
BCs aren't high energy necessarily (not well bred ones). They are athletes who CAN do amazing feats of stamina and agility, but they don't require their human partners to sign up for marathons or find a mountain flock to shepherd.
What they do require is consistent, fair, leadership and a purpose in life. That purpose may only be driving around in the pickup with the boss, but that works very well. Or spending half the day wandering the woods and the rest of the day snoozing at your feet while you work.
They like to learn ways to help - I knew a guy whose dog just hung out with him all day, but the dog learned over his lifetime an amazing array of parlor tricks, just from figuring out what his human buddy wanted. That's the dog I've mentioned before that could find money of a particular denomination, open the fridge and pick out beverages by name, etc. Typical stuff a bachelor would teach a dog. [

]
So what about those shelter dogs? What goes wrong, typically? Most families have time blocked out in slots: "Getting ready for school time," "school time," "dinner time," "homework time," "social time." Most Border collies don't do well put in the box called "dog time." Many dogs don't, really, but they adjust to some extent. It's particularly disastrous for many BCs to be left to their own devices one moment, then played with for a short intense time, then left on their own again. They are just not built for that.
The great thing about a smart dog is that it learns very easily. The bad thing about a smart dog is that it learns very easily. When a BC is sometimes offered interaction and sometimes left alone, the dog will often start maneuvering to get the attention he craves. Seperation anxiety is very common and very intense in this breed. That's where the dog will go on rampages of noisemaking or destruction or both - trying to figure out what it is you want him or her to do in the time you've left the dog alone. Aggression can be a problem as the dog juggles his notions of where he fits in the pack.
A BC craves work, like a Beagle craves trails (or maybe peanut butter cookies, or both).
Working with you is good. Not working and
with you is ok because you set the tone - your passive presence reassures the dog that HE can be passive. Working BCs learn to accept solitude because they are just plain tired and eventually they get a sort of concept of "taking turns" (
not working,
but work could come soon, like a dog patiently waiting by the dinner bowl).
People who work full time and decide to share their lives with a Border collie often do so at a great expense of time, money, and their social lives. Everything you mention sounds great to me as a person who fosters and rehomes rescue Border collies, but if I interviewed you, I'd have to say, "Are you aware that these
structured activities are not an option?" You might be able to miss a day or so, or even a couple of weeks, but eventually (unless you are very lucky in the dog you find) you'll have some of the fabled "horror stories" to add to the Border collie mythos.
I strongly suggest that you talk directly to a Border collie rescue group in your area. Contact me privately if you'd prefer and I can give you a referral. Good luck!
ETA: The pup whose picture you posted looks like a mix. A NICE mix. That would be a wonderful entry into the world of Border collies. I often recommend a mix to people who want the active dog but might not want to go "all the way" with formal training, etc.