Flash memory manufacturers are notoriously secretive about the actual endurance of their products, likely because it's now embarrassingly low.

Specifying endurance in "thousands of hours of FHD video" implies large sequential writes, or in other words the best-case for write amplification.

They also substitute parts all the time. Even the “best” brands have been known to do this. From different controllers to swapping TLC for QLC flash.

Better manufacturers do give you a TBW endurance rating, and document what type of flash is being used (SLC, MLC, etc.).

I used one of these Micron cards in my RPi4, it has high write endurance and also an A2 performance rating so it can support the IOPS needs of a boot drive. https://www.mouser.com/new/micron-technology/micron-i400-mic...