I´m with you on Bakula...he really comes across as a softie most of the time...but I never found that unfitting. He´s the first human really "out there"...there is no Federation and Starfleet is very young. So I think it´s believable that they don´t really know yet who is real "Captain material" and who´s not. And I always thought that he didn´t get the Captain´s Chair based on qualification and much more based on who his father was. That he´s very soft is also the reason why he works great with T'Pol as kind of polar oposite. Thinking about it now I wonder if he was actually cast specifically because they wanted that kind of dynamic and were actually looking for the "softie type".
The problem is not with Bakula, it's with the writers, they make him say and do the stupidest of things. Like the whole "sickbay" episode for example. I can't see no purpose to that episode except to prove that Archer is a stumbling idiot.