Yeah I have one on my current Sportage but as you say it really is only a benefit to those in the back.
Exactly the same with the VW Tiguan that we had. It was nice for those in the back (which happens about twice a year in our case!) but you were completely unaware of it in the front, other than the slight creak from it in very cold weather or the greenhouse effect in very hot weather (even with the blind closed)! As a result we didn’t opt for one on our new BMW X1 and neither of us has missed it one bit. Fine if it’s standard kit, but not worth it as a paid option IMHO, unless you permanently carry rear seat passengers.