Red Alert 2's was pretty great, though not to the same level as C&C's.
When it started it blasted out at full volume, "WARNING! Military Software Detected!" which, at one friend's house, caused his mom to yell up the stairs at us "WHAT ARE YOU BOYS DOING???"
Edit: hah, beaten.