Some actors are good at transforming themselves into different characters; other actors are brilliant at playing a single role or type over and over. That doesn't make them bad actors, just a different kind of actor. And actors in the latter group are often more famous, because they present a consistent and familiar image rather than vanishing inside their roles.
People don't cast Sean Connery because they want a chameleon. They cast him because they want Sean Connery.