Artificial Intelligence with the mentality of a teenager/child and a hand on the button of a nuke is never going to end well. Bad wigs/extensions are still a staple of this show. Sexism exists among the Asgard, who knew? Daniel has nothing to do with them but gets a ship named after him, meanwhile Sam saved one of their planets and gets squat. The Sam/fake!Pete storyline brought everything to a crashing halt every time they returned to it.
At least O'Neill is among the living again and still strong with the funny. Fifth is wonderfully psychopathic and naive at the same time. Finally a weapon to combat the Replicators. The birth of RepliCarter (even if she ends up being underused in the long run). Also much prefer the new actress for Weir who is more believable for the qualifications this character is supposed to have. Finally the long overdue promotions for O'Neill and Carter. Teal'c and Carter make hilarious awkward small talk that comes to a crashing halt at the mention of Pete, go figure. Daniel and Weir are great together, oh the snark.