Agreed. The scene with Adama on the hill was such a lovely coda to a series that had been playing with concepts of death, rebirth, and change for all four of its seasons. But then came those tacky five minutes which were made even worse with the inclusion of stock footage of those oh-so-threatening Japanese robots.
So, the moral of BSG is that I'm supposed to be afraid of my Roomba?
The hokey spiritualism also irritated me, but it seems like said hokey spiritualism is now a prerequisite for most televised SF (cf. Lost, Heroes). The networks seem to think the masses need a healthy serving of God with their spaceships and time travel or else they might change the channel.
Still, the first hour of the was as good as anything the series has ever done. And I liked how the original series' theme music was incorporated into the scene of the fleet heading for the sun. And Olmos should get an Emmy nod for breathing life into a character that could easily have turned into self-parody in the hands of a lesser actor.