This is highly dependent on screen size and viewing distance.
On a computer screen or a phone screen? No, it's not really noticeable. Hell, on some phone screen sizes/distances, you might not even be able to tell 720p vs 1080p.
On a 120"+ projector screen? Yes, it is definitely noticeable.
I have a small home theater and picked up a refurbished 4K LED projector (Epson 3200) coming from an old 1080DLP (Viewsonic 8200) - massive difference!