Canon
Canon EOS cameras introduced from 2010 or so (with the exception of some EOS M models) usually work great over both USB and WiFi, although older models can have particularly slow WiFi chips.
The functionality of PowerShot models varies significantly, so do check the details for your specific model.
Click a camera model for more details.