LtCol. Cameron Mitchell of SG-1:
This character was the leader of the SG-1 team. Whether it was the way the character was written or what, LtCol Mitchell came across as a transplant of Commander John Crichton from Farscape.
Fortunately, the SciFi channel did not renew SG-1 for its 11th season, so SG-1 has been exiled to the world of direct-to-DVD movies.