Everything a computer does uses resources so every extension will have some performance impact, though you usually won't notice the difference from any one extension. As a general rule of thumb, the more an extension does the more resources it needs and so the bigger the impact. Some extensions free up additional resources (eg by blocking ads or trackers) which may also result in a net performance gain dependant on the page you're viewing.

A large extension on disk doesn't necessarily use more memory and CPU time than a small one, but it is more likely to. The only reliable way to tell which extensions are resource hogs is by benchmarking them.

Disabling extensions not in use is a good idea, though personally I'd uninstall them instead.