Find SGA Stories in a Specific Genre

Back again, lol. Been scouring A03 and fanfiction.net, wish wraithbait was still up and running had some nice looking fics I'd love to read on it. But in any case. This is probably a long shot, but are their any fics where team or whole of Atlantis watch the show? Where they find it somewhere or it appears in a room and they watch the show? I've loved these fics in other fandoms and am curious if their are any for SGA. Or even family members back home are brought together to find out what their family members are going through on Atlantis by watching the show?

Also I just read one fic where someone wrote Sheppard up cause he was with Rodney and had to be interviewed. I'd love some long one's like that were someone writes him up for being with Rodney, but would also love if the marines on the base and at SG-1 stood up for Sheppard/McKay. Bonus if the public gets involved if John is sent back to Earth.

Looking for any John/Ronon fics where his friends kidnap John in an attempt to get Ronon to join them. Mpreg is fine.

Also any John centric fics where the IAO or command or even military force him to do a undercover ops and he's not allowed to tell for a long time or short time and he gets captured and they write him off, but the team or someone in Atlantis or SG-1 find out and they launch a rescue mission. Any pairing is fine.

Any John/Rodney where John is the victim of Gay Bashing/Bullying, bonus for protective Atlantis and or team. I've seen some of Rodney being the victim, but am curious if any of John being the victim. Would love if the marines on Atlantis or even SG-1 comes to his rescue, but not necessary.

Are there any fics where John was in an abusive relationship, maybe with a past person in command or even a lover aside from Nancy and they come to Atlantis and the team find out about what happened?

Any pairings are fine with me. Thank you in advance. :)