It depends on the level of detail of the shot and the size of the picture displayed, obviously. Where crop magnifications can pop up the differences in-between. There are human limitations, as well.
Which means a much more noticeable difference from SD to HD or from 720p to 1080p rather than from 2K to 4K or even as far as the next 6K or 8K steps concern. Except if you'll print a large format. Then, the difference can be crucial between to have it or not to have.
It is what it is. Like when you won't probably notice the difference between 10 to 100 millions in your bank account as much as from 10,000 to 100,000 or from there to 1 million.
There's always a sweet spot in everything. In my country we're used to say the virtue is in the middle, for some reason ; -)