Well, as you asked!
They are both [TNG and SG-1] good shows, but they are both very "safe" TV.
I've recently re-watched TNG on DVD and although it has some very good episodes, it has dated horribly - worse than the original series in some respects - and the overwhelming feeling I have looking back at it now, despite some very, very good stories, is that it is just too bland - they are all just far too nice!
And Stargate, in either flavour, has never been anything more than switch-off and watch TV. Don