You have the humans of the enlightened future meeting a team of military personnel from the past, lead by a man who tries to avoid enlightenment whenever possible. He'd probably end up in Quark's playing darts.
Carter is going to immediately frustrate any attempts to limit damage to the timeline (not that it makes sense given that they'd have to be from a parallel reality) or invoke the prime directive. She's going to be full of questions, and she knows enough about advanced alien technology that she'll probably be able to figure out more than they'd want just from observation. She'd also probably figure out how to use the wormhole to get back home, being something of an expert on the topic.
Daniel is going to have the unique experience of being an archeologist that is now a relic of the past. Not much for him to do as a linguist since they have universal translators, though it would be funny if they brought it up and he thought they had all just been speaking English, since everyone in their galaxy does for some reason. It'd also be funny for him to be recognized by the prophets or Q, as though they knew him from his brief period as a vorlon or whatever.
I think Dax and Teal'c would hit it off, they have so much in common.
And things would get very confusing if someone activated an emh.
Also probably for the best that the Atlantis team isn't there, as O'Brien would have some awkward questions to answer. Besides, they're already too busy crossing over with Enterprise and answering their own awkward questions about Tripp.
Oh, and I really hope Jellico is visiting the station.
The Prime Directive wouldn't even apply. The Tau'ri have been properly FTL capable ever since they started producing the F-302 in what, the year 2000? As much as Starfleet would hate it, SG1 represents a humanity that is wearing the big boy pants just like they are.
If we aren't being strict about warp technology specifically as the measuring stick, I think the gate network itself would qualify, even if they weren't the ones that built it.
That said, the principle of noninterference likely should apply to some extent at least. After all the trash talking they've done over the years about people in the 20th/21st century, it would be crazy to let a military unit from that era get access to anything that might help them advance technologically. Especially when they've already got a history of capturing and reverse engineering alien technology. And all the more so when it becomes clear that any technology they do get their hands on will be used almost exclusively for the purpose of fighting alien civilizations (and perhaps even others on their own planet).
In the long run, if a stargate found it's way onto DS9 or Bajor and permanent relations were established, I could see the federation providing aid to the Tau'ri to help them fend off the Goa'uld and/or the Ori, which they could justify because they would be preventing an advanced civilization from exploiting a technologically inferior one. But I have to think it would take them a while to get to that point.
Like TNG, the pilot episode is a solid intro, but the first season is rrrough. Y'know "Code of Honor?" The same writer submitted the same script as "Emancipation."
Decent formula episodes: Cor-Ai (s1e16), A Matter Of Time (s2e16), The Other Side (s4e2), Scorched Earth (s4e9), The Fifth Man (s5e4), Revisions (s7e5).
... and honestly the episode everyone goes on about is not a bad introduction. Window Of Opportunity (s4e6) stands alone.
I love how they have said that big sploosh vaporizes everything it touches, but then the effect is literally just water. The visuals used have always made it hard for me to imagine it being dangerous. 😅