Three off the top of my head if you don't mind slash and love Rodney:
Face Value by minnow1212 (http://www.livejournal.com/users/minnow1212/209075.html#cutid1) long; mild slash; Zelenka gets a good showing too. As a bonus this story fits with the current Superpower challenge.
A Beautiful Lifetime Event by shalott (http://www.intimations.org/fanfic/stargate/lifetime_event.html) novel length; slash at end so if you don't like that you can just drop out when things get slashy
Transcendental by shalott (http://www.intimations.org/fanfic/stargate/transcendental.html) novel length; intercut with occasionally offensive slash. It pushed my boundaries hard, but the story was too good for me to stop reading.
no subject
Face Value by minnow1212 (http://www.livejournal.com/users/minnow1212/209075.html#cutid1) long; mild slash; Zelenka gets a good showing too. As a bonus this story fits with the current Superpower challenge.
A Beautiful Lifetime Event by shalott (http://www.intimations.org/fanfic/stargate/lifetime_event.html) novel length; slash at end so if you don't like that you can just drop out when things get slashy
Transcendental by shalott (http://www.intimations.org/fanfic/stargate/transcendental.html) novel length; intercut with occasionally offensive slash. It pushed my boundaries hard, but the story was too good for me to stop reading.