Find SGA Stories in a Specific Genre

I'm interested in locating stories with these themes:

1 - Stories situated between the Siege III and Intruder (or similar situation in stories where the expedition is separated from Earth from longer periods) where Sheppard is really worried about being removed from the expedition or even a scare happening in Earth where this almost happens. But in the end he continues in the expedition and as militar commander.
Ex:
Retrograde series (especially 'Vegas')
Frozen Into Marble (part of the Two-Body Problem series)
Keri (part of the Keri 'verse series)

2 - Stories where Sheppard receives a disability but manages to not only remain in Atlantis but keep his job as military commander. The disability must be permanent or at least looking permanent (in case they manage to resolve the problem later) and not interested in stories during the first season (where they really don't have acess to Earth anyways).
Ex:
Three for the Price of Two and his sequels
Silent Sounds series

3- Stories where Sheppard is in McMurdo for other reason than disobeing orders.
Ex:
Not so Special series

4 - Stories in Atlantis where Sheppard is both military and a pilot but isn't Air Force. I already know the Keira Marcus stories where he's a marine.

I'm interested in find stories with the following themes (preference gen stories):

1 - Rodney and Carson working together to resolve a serious medical problem, but not simply using some Ancient healing device or fixing the malfunctioning device who caused the problem in first place, but creating/adapting something to do the job, like in Life Altering and Perchance To Dream. Bonus points if the solution is used later to help other people with the same problem.

2 - John tries to reconciliate with his father before is too late, maybe before departing to Atlantis or when he is in Earth between The Siege III and Intruder (the story can show later he sending letters to his father when in Atlantis and such). Only interested in gen/canon-compliant stories (almost all stories I found with this theme are McShep or written before Outcast, with a non-canon father). The only story I found similar to this was situated post Enemy at the Gate and envolved time travel (One Less Regret)

3 - Die Hard-like stories like in The Storm/The Eye with John acting alone to rescue friends, but without collapsing from injuries in the middle of bringing them back and needing help from them (like many of the existent similar stories) but keeping going until reaching the safety of Atlantis. Stories with him doing that under effect of drugs (like Red Rain) or in some berserker/feral state are valid too if he is sane enough to be able to identify friend from foe.

4 - The Atlantis expedition turns againts John, maybe by some type of serious misunderstanding/false accusations (like Hypothesis), or they are being affected by something (like the episode Irresistible) or is John who is being affected by something and the others want only to help him.

5 - John is removed from command and forced to leave Atlantis (maybe for medical reasons or some higher-up with a personal vendetta against him). I know about having a lot of these type of stories, but the very majority are slash, with Rodney going with him to Earth, I want some gen stories, with him trying to survive (or not) alone without Atlantis and his friends, maybe pursuing a scientific career or even isolating himself in some cabin in the woods, but I not want stories with him returning briefly to resolve something only he can do only to be kicked out again after (like Dumb Luck).