Hi Daniel
I am Dave, I will help you with this.
You have Windows 10 64bit installed.
Program Files (x86) is where 32bit applications are installed
Program Files is where 64bit applications are installed
ProgramData is where application date is stored, this includes settings, database data and other files that need to be changed, because files in the Program Files folders is not editable
A further complication is in C:\Program Files is a hidden folder named WinodwsApps and that is where all Microsoft Store Apps and games are stored.
I do agree with you that this is a complex folder structure, some if it is legacy form previous versions of Windows, but this also allows us to install both the 32bit and 64bit version of software if we need to and the ProgramData folder and WIndowsApps folder are there to improve system security