indeed if you want to use a more modern suspension fork in an old bike I would recommend to first of all look for one with very low A-C height, like SID before ~ 2000 with 63mm travel, which is depending on exact model just 455mm, or Skareb/R7 with 80mm which are also just 45-46cm.
Than also run those with as max as possible SAG, that the A-C difference compared to old fork is <2cm.
But some users may say that by having a higher fork you get not just more comfort by the better performing fork, but also better comfort as the front comes higher and even a bit more modern geometry with more rake, better for higher speeds and downhill.
Also objectivly our bikes from the 90ties had a rather race and uphill oriented geometry, which isn't fitting every rider (any longer).
Still, as other said above already, too extreme changes may lead to an negative impact on riding handle.