I loved Aperture. Hated LR. Came to CO somewhat because I had nowhere to turn. I'm not a pro. Do not have a large catalog. And do not like having to use multiple programs to get through post. In this regard CO meets my needs and I've come to really like it and enjoy working in it.
It is extremely flexible in terms of layout and workflow. I still have a few minor complaints about DAM but they are hardly deal breakers. I do not use Sessions.
I do not like software subscriptions. I have a PC (Personal Computer) for a reason. It was liberating AND gratifying to finally wash my hands of everything Adobe.
At this point my only gripe is that CO is not speedy on my new iMac. It isn't slow, just not fast. More RAM might help a little. Still not a deal breaker. I'm pretty much dedicated to CO at this point and have no regrets.
Still mad as hell at Apple.
I don't think CO is the fastest kid on the block but then again, I've not used Lightroom for anything but making web galleries for years. I'm biased as I've used CO exclusively since V3. But I'm not a dam user so I'm a sessions guy and it works perfectly for my business. I'm still a bit behind on hardware, ivybridge i7 quad, and 32gb of ram and I'm not unhappy with performance. My usual workload is 8 to 10 images per shooting day for work and a bit more or less when shooting for fun. When I work on my retina MacBook or hot rod Mac mini, there are speed differences but they are manageable.
I too really don't want to go the subscription route, and currently find PSCS6 to work out fine. I'm also learning Affinity Photo, but a couple of decades of muscle memory is hard to overcome.
I shoot almost all tethered for work with CO and Capture Pilot which is a very valuable tool I'm my work. I've had occasional glitches with tethering over the years with MBPs but it has been very stable recently. USB3 cameras need a powered USB hub to work, or just use USB2 which is flawless without a hub. The slowdown of transfers with a 5Ds is not a problem for my work but it may be for others. I regularly use a 30' active USB extension cable, usb2or3 both work fine.
Unless something major changes I'm not going anywhere.