Past perfect (Plusquamperfekt, literally "more than" perfect, in Latin/German grammar) is only used relative to something else already happening in the past. In other words, it's used to say that something happened even earlier than something else that you're talking about.
It doesn't matter how long in the past it was in absolute terms, whether it was two seconds ago or hundreds of years ago.
Ich habe die Schule vor langer Zeit verlassen, nachdem ich viele lange Jahre dort abgesessen hatte. (I have left school long ago, after I had spent many years there.)
There are two time levels in this sentence, the time when the person left school (in Perfekt) and the time when the person was at school (in Plusquamperfekt), and that's the only reason why Plusquamperfekt is used and needed in this sentence.
In spoken German and in some dialects, people do use Plusquamperfekt in place of simple perfect, maybe to emphasize it. It always sounds clearly wrong from a standard German perspective.
Wir hören Musik von früher
Schauen uns verblasste Fotos an
Erinnern uns, was mal gewesen war. (from: Die Toten Hosen, "Altes Fieber")
Plusquamperfekt is incorrect according to the grammar of standard German here because "erinnern" is in present tense. It would be correct and needed if "erinnern" was already in the past: "Wir erinnerten uns, was mal gewesen war."