The Galactica was a great ship, but it was the skill and determination of the crew that made it so hard to beat.
The crew of the (Next Generation) Enterprise was just great at making shit up to get out of sticky situations. Techo-babble to the rescue. I guess it makes sense since their mission was one of exploration.
Ships in the Stargate universe, like those in the BSG universe, were actual warships, and they just kicked ass.
Give me an Aurora class ship crewed by Adama and his people, plus throw in Data for some last-minute techno-babble in case we need to kill some Borg.
)