cPAddons is designed with system administrators in mind. It allows sysAdmins to moderate requests for installations, force upgrades etc.
If you install a cPAddon via the "Site Software" section of the cPanel interface, then it will appear on your website.
If you unzip a cPAddon manually (e.g. WordPress), cPAddons will not manage that script.