I suspect the actual write cycles are much better than what is advertised due to the huge SLC caches. The 980 PRO has ~114 GiB of it. If your writes have good locality (e.g. you write to the same location over and over), then only the SLC will get used. Consider a 980 PRO, which has an endurance of 600 drive writes. I assume that's calculated based on the worst case of filling the whole disk, causing every cell to get overwritten each pass. But if you don't fill your whole drive and the wear leveling was perfect, then you will be able to use every cell to their maximum endurance:
11.4% * 50k cycles + 88.6% * 600 cycles = 6232 cycles
Can any one confirm this?
The 980 PRO does not have 114GiB of SLC. It has 1TB of TLC. It will use varying amounts of that as SLC to provide a cache of between 6GB and 114GB. How much TLC gets treated as SLC, and which physical blocks of NAND get treated as SLC will vary over time and depending on usage patterns. Like most consumer TLC SSDs, data that is initially written to SLC will generally be compacted and written out to TLC blocks during idle time, so mere spatial locality of writes is not enough to ensure that your data only gets written to SLC and never moved to TLC.
Since the specific physical flash blocks that get used as SLC changes over time, there is no "SLC section" that can be regarded as having many thousands of P/E cycles. A P/E cycle on a SLC block contributes to the wear of the general pool of available NAND flash, and the drive will cease functioning as soon as the flash is too worn to be used as TLC.
Most consumer QLC drives are much less aggressive about flushing the SLC cache during idle time, so choosing to only use the first quarter of a QLC drive will get you a lot of SLC-like characteristics for performance and wear.
The Enmotus FuzeDrive SSD is a QLC drive with an actual static SLC partition the way you imagine it, with blocks that are permanently treated as SLC for the lifetime of the drive and mapped to a specific range of LBAs, and the SLC portion and QLC portions of the drive have independent wear leveling processes.