I think the people who are whining about Tim are in for a rude awakening if they think the next CEO is going to be much different. I suspect the Cook hate boils down to homophobia because, by any objective measure, he's been an outstanding CEO, the best Apple has ever had.
I don't like how buggy Apple software has gotten, but I'm also not delusional. Apple software has always been pretty buggy. The whole Snow Leopard update was an outright admission that Leopard was a rat's nest of bugs. I certainly don't long for the days of Conflict Catcher on my classic macOS machines either. If only people would stop deluding themselves into believing that the past was some golden age.
Apple is now a HUGE corporation and huge corporations aren't nimble and rarely take chances. Anyone expecting the next CEO to throw open the floodgates of innovation is going to be sorely disappointed. Apple has been very innovative under Cook. Love it or hate it, Vision Pro is a very innovative product. It's not for me, but I'm not going to pretend that it isn't some very cool cutting-edge technology either.
It's also not like Apple has a backlog of wildly innovative products that wicked Tim Cook is keeping from the world. The next CEO will likely stay the course. Cook's formula has worked exceedingly well for Apple. The next person isn't going to make any radical changes when the company is raking in the dough and sitting at the top of the most admired companies list for yet another year. This holds doubly true if the next CEO comes from within Apple, ie: Ternus.