One of the weird ones that will never appear on youtube is the Bosphorus. The surface flows north to south but there is a strong current down below flowing the other way. Difficult to make a film of, though, but it is caused by different levels of salinity.