Google’s John Mueller said he would “caution against assuming that you need to do this level of analysis for all URLs on a website in order to achieve optimal SEO" when it comes to reviewing bad redirects or CSP settings. Why, because bad redirects or CSP settings are often simply visible when doing normal browsing, and if you see it, then that is enough.