Sg1 will probably be one of my favourite series ever. But from my perspective it really didn't age that well. Not talking about graphics or CGI here, but more on a action POV. A few jokes I probably wouldn't bring today anymore, a few weird decisions regarding the plot and the cast and, because of the episodic character of the show quite a few plot holes.
SGA on the other hand is a great show, which aged just as well and is the one I actually recommend people nowadays if they want to take a look at the franchise.
I suppose it could have. My problem is that when I watch a show, it's mostly for the competence porn. SG1 and SGA were that, in spades. SGU wasn't that, at least in the beginning, and I don't typically last beyond three episodes when it's clear that the genre isn't even what I'm looking for.
Stargate: Battlestar Galactica. It was so, so apparent at the time that they saw the success of BSG and wanted in on it. It's honestly hilarious because Trek tried to pull the same shit with Discovery, and then with Picard s1-2 before they reversed course and were like "what if we just made the type of Trek that Trekkies like?" and then comes Picard S3 and Strange New Worlds.