This always seemed like the cheapest way to manufacture tension for me.
There are serious core philosophical differences between Sisco and Picard. There are multiple avenues that could have been used to create conflict and tension.
Instead we get Sisco hating Picard because he blamed him for that shit with the Borg. At best the first impression of Sisco is that he’s kind of an idiot. If you dig deeper Sisco is a victim blaming asshole who hates Picard for serving as a meat puppet after getting brutally violated by the Borg.
You could have just switched the reason for Sisco to hate Picard to the fact that he had his chance to strike a fatal blow to the Borg and refused for reasons Sisco would see as sanctimonious.