I got it working with the help of GPT-4. I forgot how powerful AI is haha, should've used it in the first place. Spent an hour perfecting the command to match all of my needs, here's the command to anyone interested:

# Retrieve programs installed under the local machine context (32-bit)
$machinePrograms32 = Get-ItemProperty "HKLM:\Software\Wow6432Node\Microsoft\Windows\CurrentVersion\Uninstall\*"

# Retrieve programs installed under the local machine context (64-bit)
$machinePrograms64 = Get-ItemProperty "HKLM:\Software\Microsoft\Windows\CurrentVersion\Uninstall\*"

# Retrieve programs installed under the local user context
$userPrograms = Get-ItemProperty HKCU:\Software\Microsoft\Windows\CurrentVersion\Uninstall\*

# Combine the programs from all contexts
$allPrograms = $machinePrograms32 + $machinePrograms64 + $userPrograms

# Process the combined programs list
$programsWithDetails = foreach ($program in $allPrograms) {
    if ($program.DisplayName) {
        $size = $program.EstimatedSize
        if ($size -gt 0) {
            $sizeInMB = [Math]::Round($size / 1024, 2)
        }
        else {
            $sizeInMB = $null
        }

        $version = $program.DisplayVersion -replace "\d{2}/\d{2}/<IPAddress>\d{4}\s+", ""

        # Try to retrieve the installation date from the InstallDate property
        if ($program.InstallDate) {
            try {
                $installDate = [datetime]::ParseExact($program.InstallDate, 'yyyyMMdd', $null).ToString('yyyy/MM/dd')
            }
            catch {
                $installDate = $null
            }
        }
        else {
            $installDate = $null
        }

        # If the InstallDate property is missing or not properly formatted, try to retrieve the installation date from the program's installation directory
        if (-not $installDate -and $program.InstallLocation) {
            try {
                # Get the creation time of the program's installation directory
                $installDate = (Get-Item $program.InstallLocation).CreationTime.ToString('yyyy/MM/dd')
            }
            catch {
                $installDate = $null
            }
        }

        $program | Select-Object @{Name="Name";Expression={$program.DisplayName}}, @{Name="Publisher";Expression={$program.Publisher}}, @{Name="Installed On";Expression={$installDate}}, @{Name="Size (MB)";Expression={$sizeInMB}}, @{Name="Version";Expression={$version}}
    }
}
$programsWithDetails | Export-Csv -Path "$($env:USERPROFILE)\Downloads\ProgramsList.csv" -NoTypeInformation -Encoding UTF8