Starting from version 22.5.2 Photoshop stopped opening some tif files. The issue is related to a previously discovered vulnerability, the escalation of which, under certain conditions, may lead to arbitrary code execution - Adobe Security Bulletin.
Important: The problem is not with Photoshop, but with third-party software developers who do not keep track of current TIF specifications
A temporary solution to the problem is to convert files in third-party editors that completely update the structure of TIF files (for example, xnView, ImageMagik, etc.); such files can also be converted using the Camera Raw plug-in (via Bridge).
We all hope that Adobe can solve this problem and find a way to bring third-party files to modern standard. But I recommend that you independently contact the developers of programs whose files Photoshop cannot open. Notify them of the problem, recommend to contact @Jeffrey Tranberry using this community. Jeffrey can provide technical information to developers to solve this problem.
List of apps that have problems (according to your feedback):
Affinity Photo (no feedback from users, is the problem fixed in 23.0.1)
This change was originally made to reject Tiff files that lacked an attribute which could pose a security risk. Engineering is working on a change to amend that behavior to calculate the missing attribute when not provided, but only under the constraint that the calculation can be made with fidelity and not cause the security vulnerability.