vrdu I don't know about the relative frequency, or about the Sims 2 error, but for Sims 1 at least, there are enough reports that the game won't launch on both platforms to say it's not entirely EA App-related. Have you tried reinstalling your VC++ runtimes yet? If not, please do so now. Open Windows Settings > Apps, scroll down to the Microsoft Visual C++ Redistributables, and uninstall everything from 2015 and newer. Don't touch the older versions.
Download the x86 and x64 versions (not the ARM version) of the 2022 runtimes from Microsoft:
https://docs.microsoft.com/en-US/cpp/windows/latest-supported-vc-redist?view=msvc-170
Install the runtimes, restart your computer, and try to play.
For Sims 2, please post in the dedicated forum:
The Sims 2 | EA Forums
And keep in mind that a patch will likely be released soon (according to EA posts on social media) and hopefully clear up most of the launching and crashing issues.