Personally, I liked this episode, how they tied it in to some of the SG1 episodes, without having the SG1 plot overpower it at all. Seeing everyone's fears I thought was important, as these characters face horrible enemies and have to fight and kill on a semi-regular basis, so they are bound to have built some pretty substantial fears over the years. You get to see inside all the characters.
The 'goatee' line was the best in the show I think. The death of Doctor Heitmeyer was sad, but she had only bit parts in a half dozen shows a season, if that, so if the writers had to kill someone off, she was a logical choice. There have been too many deaths and too many character losses, I sincerely hope they do not have any more for this season.