You might have a problem with the file download. I downloaded the community msi and after an UAC prompt I get this. My account is a member of the administrators group. I did not complete the install but it looks like it should work.
Open a PowerShell prompt and check the file length and file hash for your file and see if it matches mine.
PS C:\Users\madne\Downloads> Get-FileHash .\mysql-installer-community-8.0.34.0.msi
Algorithm Hash Path
--------- ---- ----
SHA256 F1C6FD75F241BCB09A6A3A392D923E519AD86416486805EEEF699C5551A33EB9 C:\Users\madne\Downloads\mysq...
PS C:\Users\madne\Downloads> dir .\mysql-installer-community-8.0.34.0.msi
Directory: C:\Users\madne\Downloads
Mode LastWriteTime Length Name
---- ------------- ------ ----
-a---- 10/15/2023 4:52 PM 347348992 mysql-installer-community-8.0.34.0.msi