My headcanon is that Snapdragon 875 would've been a great chip unlike the infamously overheating 888.
I think the 870 was the highest end Snapdragon that didn't have any overheating issues for a while.
I've had the sm8250 (865 in my case) and it's a great chip that's faster in real-world conditions than the 888 hand warmer was. Now I have an 8 gen 2 device and it has no overheating issues. The 8 gen 1+ doesn't appear to have any either. I avoided the 8 gen 1 after having the bad experience with the 888.