I have a couple of items on Astarion that are like +3 stealth while obscured, and he rarely fails to stealth even in red visible areas so yea, what use is grater invis for anyone that can't pass DC15+ stealth rolls?
Greater invis was an OP spell in BG2, but shadow door was better. I guess Larian just had to nerf everything that doesn't do damage.