WIA-Loader should work with almost any camera for which a WPD driver exists. Depending on the camera's manufacturer, this driver may have to be installed separately. Some cameras require a special USB interface mode to be selected - for some Nikon cameras, for example, this is the PTP mode.
WPD drivers also exist for smartphones and mobile phones, so WIA-Loader can be used to transfer images from such a device to your computer as well.
Cameras with WiFi capability (currently in particular some Nikon Z models) can additionally be controlled directly over the network via PTP/IP, see WiFi capable Nikon cameras.
Cameras that don't come with a WPD driver can only be read 'indirectly' by WIA-Loader, i.e. images can be imported through a flash-card reader, but features like live view or camera settings are not available then.
For Canon cameras, you may have to install an additional driver, available from Canon's website.
Many cameras offer a so-called 'mass storage' mode, i.e. when you connect the camera to the computer it behaves like a USB stick or an external USB hard drive and gets assigned a drive letter. WIA-Loader can then access the camera as well to import images - only remote-controlling the camera is not possible in this mode.