this has nothing to do with Steam or Gog, its a Larian issue because they made the software
[by their design] a language pack isn't a mod and so doesn't belong in the mods folder... it needs to be in the standard language loctation under its own heading so for example a Spanish language pack would be Spanish.pak and inside a folder named Spanish @Baldurs Gate 3\Data\Localization
