The Escape Velocity franchise is kind of famous for its use of second-person narrative. JTH's Colosseum is kind of famous for its use of third-person narrative; but has anyone ever created a past-tense, first-person narrative? By that I mean the character is explaining the events of the game and missions and such from memory, like they're telling a story or writing a book or something.

Not that I've ever seen. Every plug-in and TC I've played had second-person narratives. The sole exception, as you said, is CTC with its third-person narrative. A second-person narrative would be an interesting read, however.