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.

The main benefit is the automatic connection between note names and sounds. You can easily learn written music if you can just read the note and know how it sounds in your mind.

I have AP and I'm a terrible musician but it's a great party trick!