You're a tin man, now, Frank! A tin man!
Yeah, Dale Cooper’s a great character, but he’s not the same kind of charismatic or “charismatic” as Walter Bishop, Jr., the protagonist of the film version. That guy has a weird family history with Hitler and is now a guy who looks like a cross between Satan and the Kekulaks; he wants to find the ancient gate and become the next savior of mankind; he has a weird, elaborate, and largely (or mostly) ineffective method of getting his way; he speaks in a stilted monotone that would impress a 5th-grader; and he is just generally a weird dude, and yet his plot-relevant behavior is cool and charismatic, and compelling, and fun.
Dale Cooper is the opposite of this guy, and he’s also funny and charismatic and cool. He has a plan, which is cool and cute, which we will uncover at the end of the movie, where we discover that it is all in his head, which he hopes will make him the savior of mankind. He has his wild good looks and his bad methods and his flashy accomplishments and his … more than he needs. He’s fun and charismatic and totally unfit for the command center of any government agency, much less the power structure of a country beset by its own internal turmoil.
He is a radical, and you don’t like radicals? Well, he is the quintessential power-drunk radical, and you know how I feel about radicals. And I’m sorry, but I can’t draw the same conclusion.