And regarding the Jurati Borg…I don’t know, I never found that confusing in the slightest. I think their intent came through just fine.

Yes, I was surprised to read that there was any misconception. It seemed pretty clear to me that nothing they did in the past would have altered the history of TNG/Voyager/etc.

As I recall, the order of events played out like this:

• Picard and crew entered an alternate timeline in the Picard era (25th century, ~20 years after TNG era).
• Picard took that timeline's Borg Queen into the shared past of the two timelines.
• Jurati merged with that Borg Queen.
• They fixed the timeline and returned to the standard Star Trek timeline. Queen Jurati remained in the past. At this time, "Borg Queen Prime" (the one we know from First Contact) was still in the Delta Quadrant, unaffected by any of this.
• In the 25th century, Queen Jurati re-appears with her own collective, entirely separate from the Prime Collective we've known throughout TNG, Voyager, etc. From the 21st century up the 25th, Queen Jurati just stayed out of history's way to avoid a time paradox, ensuring that the chain of events that led to her creation would still happen.

I really enjoyed Jurati's story in season 2, and was a bit disappointed that we didn't see her at all in season 3, since she and her collective should no longer be required to stay out of history's way. But at the same time, they set that up at the end of season 2 pretty explicitly. I just felt like if they were going to bring the Borg back again, they ought to least mention that there's a whole other collective of friendly Borg who are possibly much more technologically advanced than the Prime Borg and are kinda-sorta part of the Federation.