I've always liked Archer. I thought Bakula was great in the role. Admittedly, Trip was my favorite character, but Archer was a close second. He had this earnest quality to him that was great for the early seasons, but when the story called for him to be dark (like in S3 and S4 especially), I always thought Bakula delivered. I'm very grateful we got someone of his caliber to be a Star Trek captain.