The "Moments" series  
These stories were inspired by the following quote from Richard Dean Anderson, the actor who portrays Colonel O'Neill - "As much as he has his moments of adoration for Carter, he's still aware of the propriety involved in keeping feelings at bay."  Each of these stories is a short, self contained vignette.  While they are all in the same series, you don't need to have read all of them in order for the others to make sense.  Of course Moments of Adoration was the first, so you may want to start there.

Moments of Adoration

Moments of Beauty

Moments of Comfort

Moments of Decision

Moments for Eternity