Bakula did what he could, as did Blalock and Billingsley. The character and show were just kind of poorly-conceived, I think. Way too much leaning on the human heroes (esp. Archer and Trip) as avatars of Earth's childlike sense of wonder and adventure made them come off as just adolescent and incompetent most of the time, and the portrayal of the Vulcans as the collective mean-old-Reverend-from-Footloose
didn't work too well either (nor did Manny Coto's later attempt, brave though it was, to make their weird portrayal into a plot point).