Content scripts can be loaded into a page either statically, when the page URL matches a regex listed in the manifest, or dynamically, by calling chrome.tabs.executeScript (in V2) or chrome.scripting.executeScript (in V3).

Once the content script is loaded, AFAIK its execution behaves the same no matter how it was loaded.