All depends on wether you want a dog to fit in with you and your life as it is now, or wether you are prepared to get a dog and adjust your life so it can live its best life. So many people pick breeds around what they feel will for so changes THEY have to make are minimal. You are getting a new member of the family. Not an accessory. It's give and take.
We have a collie cross, and she is mental. We knew she would be so we have adapted.
She is crap on lead. ( but her recall incredible through training ) So we drive her local places she can run free! And weekends we go on moors..that's her favorite. It's beautiful to watch.
She does love to steal things and chew. So we turn a blind eye to recycling bin theft. Worst we have ever come home to is squashed recycling across the room! If we don't let her do that she will chew furniture. ( which is all second hand due to my life choices to have pets. Far more important to me than having a show home )
We all work, so we pay for a regular week walker, we also take her out on top of that and weekends have to revolve around her.
I wouldn't swap her for the world, I cant imagine any other breed, she is SO clever, and so well behaved ( through early training, and enough ongoing stimulation ) And my best friend. They are velcro dogs also. They choose one. And that is their one! Say bye bye to ever weeing on your own again......
If your prepared for some upheaval, and compromise, then just do it. You sound experienced, sensible, and able to give a collie what it needs. Just don't do what so many do and get one and expect your life not to have to change.
Good luck 😊