Thank you everyone for your help and suggestions. I tried every suggestion and still had issues. Some reinstalled games would work while other continued to have the corrupted data message.
I had originally migrated from SXOS to Atmosphere when I first upgraded to 16.0.3 after years of sitting at the last supported SXOS firmware. I remember having to reinstall my games then. Not sure if this is part of the reason I am experiencing issues now or if it is just my lack of knowledge with Atmosphere and the scene as a whole.
I forgot to mention that a couple weeks back I had upgraded my SD card from 512GB to 1TB. I believe I followed all the steps needed to migrate my emunand raw over to the new card and all the steps involved in hekate. I honestly can't remember what game(s) I had tested at the time to make sure everything went smoothly. But maybe this too is playing a role in my issues and maybe the games that load for me are the ones I had initially tested after the migration and didn't realize other games had issues. IDK...
Because I had done that SD card migration, I had a fairly recent backup of everything on my computer. I decided to try to format the SD card and recopy thing back over and redo the emunand migration like before. This brought my system back to 16.0.3 which is great but I still had issues with games showing up as corrupted even trying both the prior and latest sigpatches applied.
So I decided to just backup all my save game files and do a system reformat to wipe the slate completely clean and start fresh on 16.0.3. I reinstalled all my games and restored the save files and everything appears to be back to normal once again.
The whole reason I upgraded to 17.0 previously was because it appeared that some of the latest game updates required 17.0 like Mario RPG and Wonder. I don't feel the need to necessarily install them right now but down the road I'm know I'm going to have to eventually update the firmware to be able to play the latest games or updates.
But because of all the trouble I've had between migrating from SXOS to Atmosphere 16.0.3 and recently going from 16.0.3 to 17.0, I'm really afraid to upgrade my system in the future.
Anyways... thank you all again for your help and suggestions. It was very much appreciated.