Well, except Sean Connery, apparently. As a previously unknown, starving actor, he was grateful for the fame and success the James Bond role had given him, but he wasn't exactly a fan of actually performing it, saying, "I have always hated that damned James Bond. I'd like to kill him."
Sean Connery, seen here remembering that time Bond nearly got lasered in the dick.
Connery was reluctant to sign up for more than one Bond movie, and when he reached the "last" one, he gave away the entire salary to charity, presumably out of spite (apparently the Bond producers hate charity). As for the character's sex symbol status, Connery observed, "I think one of the appeals[h] that Bond has[h] for women ... is that he is decis[h]ive, cruel even." When the guy who advocates slapping women around to keep them in place thinks you're a little too rude to the ladies, that's some strong hate.
"... plus, did they have to make him sound so damn Scottish?"