Seriously?
“If my answers frighten you then you should cease asking scary questions.”
― Quentin Tarantino, Pulp Fiction
You seem to have little experience with software development or understanding about bugs. You
incorrectly state Photoshop has bugs due to the speed in which it
correctly reads and writes TIFFs with or without compression but don't seem to be able to connect the dots that the various software products you state don't write TIFF correctly don't appear to be buggy.
I'd rather say: If the file exceeds the limitation of TIFF and you need to export it to another product then use compressed TIFF. Then file a bug-report to Adobe about Photoshop taking ages to create said file, bordering on becoming a useless function. Unfortunately the "bug-report" part is not that easy with Adobe.
Photoshop correctly writes TIFFs with or without compression. Photoshop and no other product can write a TIFF that exceeds it's own limitations and therefore, there's a simple answer for that; PSB.
Photoshop itself is not able to read various compressed TIFF formats created by other software, even though other programs open the very same files without issues.
No, it reads TIFF's correctly and doesn't read incorrectly written TIFFs if that's what you're implying. If so say so; you've got software that writes TIFFs with bugs and Photoshop apparently can't read them. Don't use software that has bugs writing TIFFs. Simple.
So in this case your best bet is to either use uncompressed TIFF or PNG
But you stated the OP's issue (your exact text):
rightfully states that you can run into the 4 gb limit when saving uncompressed TIFF files. Doesn't matter then,
he can't use TIFF or PNG. HE HAS TO USE PSB. And he should.
It's all a question of pragmatic choices.
No, it clearly isn't. Because the choice of what format to save when the 4 GIG limitation is reached isn't pragmatic;
it's PSB.