I've written a lot of short stories, which you can find here.
That's a lot to wade through, though, so I've organized many of them into series. If you're looking for a particular type of story, I hope this helps.
I rarely write sad endings, and I do leave warnings about things that you might want to avoid. If a story is tagged Author Chose Not To Warn, please read the tags, the notes, the warnings.
BBC:
Just Johnlock / 26 standalone stories: These are all stories that take place in BBC world. Some are alternate first meetings, canon fixits, and missing scenes. Many are fluffy, and some are angsty. Basic Johnlock stories.
Speculative Shorts / 22 standalone stories: These stories involve a degree of magic, fantasy, or science fiction. What-ifs and Twilight Zone moments. Again: fluff, angst, and Johnlock.
Those are my two main series, and most of my stories belong to one or the other. No story belongs to both of these series, so these are the two main places to find my short fiction. Neither series is complete, so you will see additions.
I do have some other series that overlap with Just Johnlock and Speculative Shorts. Some of these are one story arc told in multiple parts.
Many Happy Returns / 12 standalone stories: These are all variations of Sherlock's return from Reichenbach, each of them a fix-it with a happy ending. I will be adding to this series.
Random Strangers / One story told in 5 parts: John is a former POW who only knows Sherlock from the letter he was forced to write to a serviceman while in rehab. Their relationship begins in wariness, progresses through sympathy and understanding, eventually to love. Covers events of the series from a different first meeting through The Great Game, Reichenbach, and finally retirement. This series is complete.
May 4 / 2 parts: An amnesia story. Memento Mori: John has undetected brain damage (caused from the fall he took when the cyclist hit him) and can't remember what happened to Sherlock. In Absolution, Sherlock deals with John's amnesia and tries to atone for leaving him. This series is complete.
Author / 5 standalone stories: Writing and writers (usually John). I may add to this series.
Happiness: 2 parts, so far; two related stories that can be read independently. In Happy, John reflects on his long estrangement from Sherlock and reaches out to him; in Knight Errant, Sherlock explores his understanding of love, and explains why he waited so long for John. No more parts are planned for this, but you never know.
Seasons: 2 parts, so far; related stories that can be read independently. In Solstice, Sherlock determines that the way to win John back is the same way he lost him: so gradual that it's almost imperceptible. In Equinox, they're together and learning that, thanks to real life, the course of true love isn't always smooth. Each story takes place over one year. I have one more part planned for this series.
ACD:
Conductor of Light: 8 parts (with two more parts planned). Best described as a non-canonical, not-quite-an-AU retelling of ACD's detective and his doctor. The stories assume that Watson was an unreliable narrator attempting to make his telling of their cases acceptable for publication. As a narrator, Holmes is more reliable, but justifies many things to himself as he struggles to understand and express his feelings for Watson. Parts can be read independently, but are part of a long arc stretching from first meeting to Reichenbach and beyond.
Fin de Siecle: 20 parts, complete. Each part can be read on its own, but there is an overall arc to the stories that will make more sense if read in order. Only one part of this is somewhat explicit. The story assumes that Holmes and Watson are lovers in Victorian England who must hide their relationship. At Reichenbach, Holmes loses the battle with Moriarty and must go into hiding, faking his death for seven years; while Watson is put on trial for gross indecency and sent to prison. Reuniting after Holmes's secret return, they join the battle against Sebastian Moran, who has used his influence to corrupt the government.
Longer Fiction:
The Last Envoy: My longest work to date, 127k words. This is science fiction, but not hard SF. Sherlock is a very human alien who comes to Earth with a mission he doesn't completely understand and quickly falls in love-- with the planet, the people, and a certain army doctor. There is angst: war begins and he is caught up in events he cannot control, while still trying to fulfill his purpose in being here.
Do No Harm: 2 parts in this series, more planned. Novel-length. This is not strictly ACD; it's set in the interwar period (1920s-1930s). In Part 1, Do No Harm, Watson stands trial in 1923 for the murder of his mistress, the mystery novelist Mary Morstan. If convicted, he will hang. Sherlock Holmes sets out to prove his innocence. Part 2, Where I Cannot Follow, takes place ten years later, after Holmes has faked his death and returned from a three-year mission.
Off-Axis: These are not short stories, but a novel-length story and two novellas. Their connecting theme is parallel realities.
Synchronicity: John and Sherlock meet again, years after they were school boys together. John hasn't forgotten why he still hates Sherlock Holmes. Enemies to lovers.
The Short Tragic Death of John Watson: Thirteen years ago, Sherlock starred in a television series about an alien boy stranded on Earth. Now Molly has written a reunion episode and he's expected to join his old costars and recreate the role of Alex Tribble, now an adult returning to rescue his old friends from an alien threat. Having had some success since playing a teenage alien, Sherlock is reluctant to reprise the role. And there's another problem no one wants to discuss: John Watson, who played his best friend, is dead. NO MCD.
Blank Slate: Sherlock has been dead four years when John receives the shocking news that he's actually alive, that he's been held in captivity for the last two years. When he returns to John, he seems like a different person. Is the man John loves somewhere inside that amazing brain?
Starting Over: A disappointing blind date set up by well-meaning friends brings together John Watson, invalided army doctor, and Sherlock Holmes, asocial, "married to my work" consulting detective.
Accidental Magic: Soon after his return (TEH), Sherlock takes the case of a woman seeking stolen books hidden in her late husband’s library. He invites John to come with him. Working together after so much time apart, they begin to discover more than stolen books. This isn’t really a story about magic, except for the ordinary kind of magic that happens when people realise they’re in love and it’s time to do something about it. That kind of magic is the best kind.