My dogs add companionship, love & fun to my life, at times they've been the only reason to stay alive. They cost a lot food, insurance, vet fees, Dogwalker, boarding etc. They're not as acceptable as children to take with you places or if need to leave work early/take time off when ill. Life isn't as spontaneous & always on a timer. House is never as clean again with fur, mud, sick, accidents to deal with unless one of those that keeps dog in a utility/kitchen & never gives access to rest of house. Often end up with dog behaviour/training issues to deal with, I'd love a dog I could take anywhere with me but current one now finds other dogs scary, however its often those difficulties that really force you to learn about dogs.
My friend has collies & I meet a fair few, there all quirky & seem to be more prone to nervous/ocd type behaviours. Friends dogs go running with her & do agility, spends time each week going to training/ events. I can tell if she's had a busy few days ( still walked) as they start doing odd things & become more vocal.
They're nice dogs but are in that more specialized 'lifestyle' category for me along with huskies, malinois etc where your life has to fit around their needs rather than average pet dog. I'd easily be trained by a collie, I prefer my dogs to be less busy in body & mind.
Was it a breed rescue you tried? If your set on a collie, they would best placed to find one that matches your lifestyle & experience.