In that regard, here is some shamless self-promotion! :P You can find my fanfiction novel Some Corner of a Foreign Field here. Hopefully, you'll leave a review or give it a heart/thumbs up, and maybe I'll be lucky enough to win a shiny golden badge... (A girl can hope, right?)
I'd also like to recommend another SGA fanfiction novel, namely Samuel Duarte Aragon's Stargate Atlantis: Universal Sin. It provides an alternate ending to Stargate Atlantis, starting from season 4 episode "Be All My Sins Remember'd", and is truly some high quality writing. If you haven't already checked it out, give it a go!