Massively depends on where the texture is used. If it's for a main character that gets closeups, body and especially detailed textures can be massive and can add up fast even when compressed. Little low contrast details can definitely work fine and go unnoticed next to super hifi textures while being small themselves, though so many just make everything hifi. Bleh.

I miss when games went for lowfi art instead of the modern deluge of AAA pseudo-cinema 100G+ games or friendslop with the art direction of a two day game jam... (obviously there are outliers, but the industry trends are disappointing lately)