I am torn on this topic because I like some personalities more than others but feel obligated to give credit where credit is due. I do generally do separate a celebrity's politics and/or personal issues from his/her acting or performing talent. Streisand, for instance--I deplore her politics but greatly admire her as both an actress and one of the most magnificent voices and song stylists of the century. I normally can't stand Rosie O'Donnell, but she was perfect for her role in "Sleepless in Seattle."
Meryl Streep has been annoying and uninspired to me in many of her movies--she was a disaster in "Julie and Julia" for instance. But she was absolutely perfect and brilliant in her roles in "The Devil Wore Prada" and "Out of Africa."
I normally can't stand Ben Afleck and think he is so wrong as Batman, but he was right for his role as A.J. Frost in "Armageddon." I am underwhelmed by Bill Paxton in most of his movies, but he was very good in "Twister" and "Titanic" and was right for his role in "Apollo 13."
Jessica Tandy, highly overrated so much of the time, but who else could have played her role in "Fried Green Tomatoes" or "Driving Miss Daisy"?
Alec Baldwin is not my favorite actor, but who could have been more perfect for his role in "Working Girl?" I don't know why ya'll don't like Sandra Bullock though--I haven't seen her in a role I didn't like. "Blindside" was a very different kind of role for her, but she was perfect for it.
And we can go right down the list. So many uninspired and forgettable performances by so many big names, but almost all of them have had at least one role that they were just right for. And as for their less attractive personalities or whatever--well, like I said. I just separate that from their talent. Goldie Hawn, for instance, is well known as an unpleasant, hoighty toity, nasty bitch in Santa Fe. But who sees her that way in her movies?