Yes, there is a LOT out there and it comes in all genres! The rec above (stargatefan.com) is a good one. I especially like the way that site has episode tags by season. In addition to Gateworld, there is also http://www.sg1-awards.com as a good place to get a feel for the variety of styles and links to other fic locations. http://www.heliopolis.com used to be a treasure trove but it seems unavailable of late. Also, http://www.jackfic.com is good and although a "jack" site is not all jack-focused fic. http://www.abydosgate.com is wonderful archive as well.Originally Posted by Imo
There are loads more since as you noted, it becomes addictive. If you keep an LiveJournal, there are many authors who post update notices on their LJ's as well.
And finally, I suggest that when you find authors you really like -- find out what they read. I enjoy all styles of fic but find that the authors that write non-ship, tend to read it as well.