It could have been so much more, it could have been a great show.
The story premise was interesting.
The execution was “fumbling drunken fratboy trying to remove a bra from a mechanical bull”.
I don’t know that it would have been great, Dark. SG-1, for me, is the standard against which everything else should be judged. The continuity and canon in that series was absolutely immaculate.
Though your concept execution makes me smile :)