Bumblebee might not have been "terribly cool," but no one exactly hated him, either. He might not have been top of the list for most people, but everyone I know counted him among their top ten or so. (Which sounds unimpressive, but there were, what, about a hundred Transformers by the time the original movie came out, right?)