look up texel density. it's not a huge issue but it can look very bad when done poorly; pic related is a particularly bad example. notice how the size of the pixels varies drastically all over
it can be managed by using UV checkers, plus an add-on I can't remember the name of
it's not unheard of to give more detail to more important or smaller props / parts of a character though, so don't worry about it too much, a lot of PS1 games did it too
speaking of, I'd recommend checking out models from actual retro games to see it at its best

https://www.models-resource.com/