Yes, they can make great house pets IF you make sure all it's needs are met.
As I've said a hundred times on this site, not all border collies need to be on a farm. I bought my BC at 11 months old from a CBCA breeder (breed for intelligence not looks) and she was sold because she didn't want to work. My BC loves to cuddle.
That being said she is handful. They need to be walked. We walk ours at a min twice a day every day for a min of an hour each time. Not to mention we play endlessly with her. As well as with our eight year BC terrier mix and my two and one year old Siberian huskies.
They are not ones to be bored, they usually make up there own own fun, and you will not like what they find fun. They were breed to spend all day with their masters, so they like being with you. They are incredibly Smart, so games to improve intelligence, and teaching tricks is a great way to bond.
All in all, if you don't mind that 5/10 times your dog would rather be with you then the other dog. You having to spend a lot of time, energy, training (not to herd things on wheels, kids, cars). Don't mind ENDLESSLY throwing the ball, a border collie can make a great house pet.
Just keep in mind border collies are one of the most common dogs in shelters for a reason. Not everyone can handle one. They are not like a retriever.