There isn't an option in SIF to make it show the final assembled command that is run for every task.
However if you add -Verbose to the Install-SitecoreConfiguration command you will get some extra diagostics from the msdeploy.exe similar to:
[WebDeploy]:[Arg] -Source:Package="C:\temp\xp0\Sitecore.IdentityServer 3.0.0 rev. ...
So basically if your Sitecore package contains database users that must be deployed and the target database already contains any user (which is true for SC9.1 OOTB), you can't create the WDP in the same way you did for Azure.
From the official documentation:
Use DisableDacPacOptions to create tables or users when you are
deploying. You ...