Well, it sort of is a "super power". As you say, it won't teach you technique or musical taste, but it is a great help for improvisational music and composing.

I have played music for quite some time and have worked on my relative pitch a fair bit, and I still struggle to improvise what I think in my head, whereas a person with perfect pitch would do it effortlessly and perfectly every time.