Mods that are installed by moving files (which covers most games) work fine most of the time; you’ll probably need .dll overrides.

Mods that need certain libraries can be a hassle, or mixed bag (eg. RSMods for Rocksmith 2014 (CDLCs work fine though), RDR2 Mods based on ScriptHook.NET).

Mods that require a launcher are hard or impossible (pretty much anything on the Frostbite Engine. I think this is your best bet with it. Don’t know if OpenIV currently works on Linux or if you need a VM with shared folders to use it).