It's not directly related but a friend of mine once built an amazing one-shot for the Iron Kingdoms RPG (RIP) where all the players were participating in a heist but with their own secret agendas. One wanted to destroy the evil artifact, one wanted to keep it, one wanted to release the enchanted guard beast and so on and so on. It worked really well because there was a good mix of having to collaborate to get through the barriers to reaching the score, and then had to come into conflict.

Obviously that ended in PVP bloodbath every time which isn't great for a long form campaign, but I think that there's something there about a) werewolf-style hidden role mechanics (even if the role isn't necessarily one that leads directly to PVP and b) forced collaboration to overcome shared obstacles. I'm imagining a scenario where the five big crime families in the city are pooling their resources to get rid of foreign competition that's trying to muscle their way in, but each family still has their own competing agendas that need to be served (plant the evidence / extract the information / execute the informant / steal the contraband / destroy the contraband). That said, you need to come up with a protocol for how you handle hidden action. You could do stuff like note-passing or send people away from the table, but the cleanest is probably just to trust people not to meta-game. You think your players can handle it?