My attempt at the 'penultimate Ukyou angst-fic.' You've probably read quite a few of these by now....
Starts out as a crime drama, and sticks to it as much as it can, considering the events, and that, well, this is in the Haruhi universe. Do you think Haruhi would be satisfied with just one genre? Minor crossover elements with Higurashi, somewhat Nagato-centric.
A somewhat pretentious but still (I think) enjoyable Ah! Megami-Sama story. The idea is that in the past, the goddesses served a mistress, Lady Fate, and their mistress was opposed by a terrible brother, Lord Destiny.... Slightly alternate universe, dark, and has some lime(ish) elements.
One of my first fics. Everyone acts terribly out of character. But it was fun anyway. Oh, by the way, it's dark.