The Losers is one of the best examples of how a well oiled team should work, and it has a plethora of double-crosses
How did this thread go on for so long without a mention of Equilibrium? I haven't met a signal person that has NOT tried to make a gunslinger adept based on the Grammaton Cleric.
And speaking of Chris Evans (Jenson in Losers), Push is chock full of mages and adepts.
The aforementioned Appleseed Deus Ex is a perfect example of cyberware, hackers, and megacorps
Big Trouble in Little China is a must see, especially for the mix of "reality" and mysticism
There is a long list of movies that feel like SR and I could go on for a long time as this is a list I've created myself, but these are the ones I use for mood setting and inspiration.