Yes, if the addon is a standalone ZIP file. However, you will miss automatic updates. Most developers prefer you install the repository first, then the addon from inside Kodi.
Great for 4K movie content and specialized builds. Kodi Addon Repository Download Zip
Note: Always verify URLs against official Kodi forum posts. Yes, if the addon is a standalone ZIP file