As you noted, it’s part of the mainline linux kernel as of 2.6.26. You can verify this with modinfo uvcvideo. It will print the kernel module info. When compatible hardware is detected, it should load the module automatically, but you can check loaded modules with lsmod and load it manually with modprobe uvcvideo if necessary.