If you’re running macOS, try opening the TIFF in Apple Preview. If that works, you can export to a file format that Photoshop will open (you can drag and drop to the Desktop or a folder as well). If the TiFF has layers, I have found drag and drop to be the quickest way to get the them into PS.
I am getting the same error.
I have just created 3 HDR images using Photoshop's Merge to HDR Pro feature and saved them as 32-bit TIFFs.
The first one opens OK, but the other 2 give the error "Could not complete the request because it is not the right kind of document."
Photoshop CS6 on Windows 7-64
With tif extension these will open in CS4 and earlier, but not in CC.
Here is the file report from the header...
Output from Display Header
File Name: D:\NAME001.tif
Standard : : TIFF File
Format : : JPEG Compressed 24 bit RGB data, Q= 10
Pixels per Line : 20000
Number of Lines : 20000
Samples per pixel : 4
File bits per sample : 8
Actual bits per sample : 8
Tiled file, tile dimension : 128
Number of tiles along a row : 157
Number of tile rows : 157
Number of overviews : 10
Overview sampling method: Subsampled
Scanning device resolution : 2032 : lines/inch
Orientation : 4 : Row major order, origin at top left
NO scan line headers : non-scannable file
Packet size (16-bit words) : 0
Free vlt space (16-bit words) : 2000000000
Free packet space (16-bit words) : 2000000000
Raster to UOR matrix:
Unspecified or All Zero Matrix
They were generated by a microfilm scanner.
I tried opening them in preview, dragging and dropping them into photoshop and copying the file and changing the extension to .JPG. The file size of each of these files is big enough that I would expect a good file to be there.
I don't know what else to try. They were made on a library's microfilm reader and to return to do it again would be a 3-1/2 hour drive.
I'm hoping someone has a suggestion.