I had loads and loads and loads of fun with both X-Wing and Tie Fighter, but I had even more fun (albeit briefer) with Jedi Knight (and to a lesser extent Dark Forces).
KOTOR felt a bit meh to me, I only played it after much procrastination, and ONLY because it was a Bioware game. (The SW franchise was pretty much ruined for me at that point.) Sure, the writing was OK, but most of Bioware's other games have even better writing. I remember not caring particularly for any of the characters, and would in fact be hard pressed to recall them all. I remember Carth, mostly because of my deep regret to be unable to put him out of his misery.
It was a very bland experience for me, but then again, the last time I can remember feeling like a Star Wars fanboi was 1993 or so when I read Timothy Zahn's sequels. Come to think of it, those atrocities (beginning, as far as I remember, with Luke and Lando drinking hot chocolate; only with a more exotic spelling) were the first part of the so-called "expanded universe" that struck me, and it struck me hard and painfully.
(Expanded Universe - what happened outside, before and after the movies, and where EVERY SINGLE UNNAMED CHARACTER from the films gets a name, a longwinded backstory and fan-created, marvelluous adventures. Oh, and by the way, everyone who died in the movies miraculously got away and lived on to have more of those fanmade adventures, thereby saving said fan the trouble of actually having to create an original character.)