I watched like 2.5 seasons of sg1 a few months ago and i gave up waiting for it to get good. It definitely had redeeming moments and even episodes but by and large i found it pretty mediocre.
Thank you!