Comparing Star Trek to BSG really isn't a fair comparison. For one thing, ST got studio support where BSG was ignored since Day One. ST ran for what, 18 years, straight, in one form or another? The fact the last "leadership" team seemed to go out of their way to contradict canon (not unlike a certain other "leadership" team) is actually beside the point.
Manny Coto proved there was life in the franchise when he got the reins in Enterprise's last season - the worst episodes of the final season (including that lousy ending ep) were the result of the Killer B's direct influence.
Give a writer a rich universe to work in (like BSG), and the time to work in it (which they did not have), and you'll get good stories for years on end.
I am
Dawg