"Great" has all kinds of echoes to it - especially in today's America - but even ignoring politics, there's a faint shrill of trumpets to the word, rumble of heroic charges, clash of battles, roar of victories! "Great" cheers on competition.
"Good" has a whole different vibe. "Good" implies not competition, but values. "Good" contrasts itself with "Bad." "Good" whispers of morality, ethics, faith, and kindness.
The Washington Post has a