The only time I've needed a x100 probe was as a "cheap & nasty" substitute for an active probe, back when such devices were prohibitively costly.
They were, of course, conventional ones, but the signal I was looking at required a device with around 100 M input impedance, & was of fairly high level, so it was (just) adequate.