There are some good episodes to come, that add to the mythology of the show.
"The Tok'ra", 2 parter
"The Fifth Race", this is one of my favourites of the entire series.
Season two isn't a bad season nor is it a great season but it has less mis-fires than Season one so it shows an improvement in quality over the first season. But yes in general season three is when the show starts to be more consistant in terms of quality.