There are a few SG-1 eps that I like (Lifeboat, Shadow Play) but I'm not really a fan of the whole series.
Mostly because I want to punch a wall every time O'Neill opens his trap. I mean, I realize it's just another example of RDA playing himself in pretty much every show he appears in, but it still annoys the shit out of me.
I know one thing, I could never serve with somebody like O'Neill. I'd be walking into whirling, unshielded manufacturing equipment my first day on the job.
There are episodes where RDA plays it more straight/seriously, but in general he is pretty fast and loose with the character, so I'm not sure how you'd enjoy the show other than watching a curated list of episodes.