However, I'm still looking for more straightforward answers. Is C:\Users\MyUser\AppData\Local\Programs the folder where installers install programs for a single user only?
Applications installed to %LocalAppData% would only be available to the user that installed it. Additionally, if a user were on an Active Directory domain, it wouldn’t be synchronized to other machines.
%LocalAppData% is not synchronized between the domain, which means the data only exists locally on the machine.
Is it like a Program Files folder but only for that particular user?
%LocalAppData% is not like %ProgramFiles% other than it’s just another directory. There are significant differences between the two directories.
Is this the recommended directory for installing single-user programs?
%LocalAppData% is a perfectly valid directory that applications can be installed to. In fact, a user can install an application to any directory they have the proper permissions to, there really are no invalid application installation directories.
I want to figure out if that’s the directory to install programs to for that user.
You certainly can choose to install an application like Visual Studio Code to %LocalAppData%\Programs to this directory if you want.
Since you have been specifically interested in Visual Studio Code, I found the following documentation on it.
VS Code provides both Windows user and system level setups. Installing
the user setup does not require Administrator privileges as the
location will be under your user Local AppData (LOCALAPPDATA) folder.
User setup also provides a smoother background update experience.
The system setup requires elevation to Administrator privileges and
will place the installation under Program Files.
By default, VS Code is installed under
C:\users\{username}\AppData\Local\Programs\Microsoft VS Code.
Source: