If I'm consistently getting CAT errors on Destiny 2 PS5 with no update, is a fresh installation of the game a viable solution, and what are the pros and cons?

A fresh installation of Destiny 2 on your PS5 is a viable, albeit last-resort, solution if you've exhausted all other troubleshooting steps and consistently encounter CAT errors with no update. The primary 'pro' is that it can resolve any corrupted game files or installation errors that might be silently causing connectivity issues. The major 'con' is the significant time commitment required to re-download the entire game and its expansions, which can be hundreds of gigabytes, depending on your internet speed. Only undertake this if you suspect local file integrity as the root cause.