And, no, I don't consider humanity giving up all of its technology and scattering to the four winds to revert back to barbarism a heartening end to the series.
That wasn't exactly the point, as I've argued extensively over in the BSG forum.
Plus, the robot montage at the very end — 150,000 years after Galactica arrived on our Earth — was somewhat corny.
I like the coda, but the robot montage wasn't as effective as it could have been. I think it narrows the focus of the end to a point about artificial intelligence, when the message of the series was much wider in focus.