When an ESR is asked for, either the frequency range is given by context, or the minimum will suffice.
For PDN purposes, frequencies of interest are generally some kHz to 100MHz or so. Higher frequencies are increasingly difficult to treat at the PCB level, depending on required impedance: the inductance of pins or balls, bond wires, etc. limits performance of low impedance interconnects such as for SoCs, hence why they must have onboard bypass. For the number of pads/balls these devices have, and the impedances they require, the practical design cutoff is typically 50-100MHz. Smaller devices, with less severe impedance limits, can depend more on board design.
There's nothing prohibiting the construction of RF transmitters for instance, but indeed, typical amplifier design uses decoupling inductors specifically to raise the impedance between signal and supply nodes; an impedance above Zo affords series decoupling, just as an impedance below Zo affords shunt decoupling. This, along with techniques like 1/4 wave structures to notch out carrier and harmonics, affords high isolation in various bands or ranges, without demanding impedances and ratios.
Or for another example, there are various integrated RF microcontrollers, from ST, ESP, TI, etc., operating in the mid 100s MHz to low GHz, which require fairly modest bypass near the RF section (one or two caps, say), because the power levels are low and thus impedances fairly modest.
Regarding context, there's both the context of the application itself (operating frequencies and harmonics), and the capacitor's context, i.e. what it's connected to. Typically, ESR is most important at the characteristic frequency with respect to connected inductances (e.g. component body and trace inductance). And typically these will be in the low MHz range, comparable to (below or near) the SRF of the part itself (which is defined by its body inductance).