We have devices sending telemetry and occasional OTA updates without urgency (if it takes a few hours to get it over it’s not a problem).
If you need consistent MB range traffic for cameras I wouldn’t advise it but for low (5kbs) traffic it can be attractive. A few thousand bits can encode quite a bit of information. Don’t be fooled by the “kbs”.
The problem is that the application of the rules is inherently usage-specific.
For example, with the 1% duty cycle limit it is totally fine to have a transmission take 30 seconds - provided you only send 1 transmission an hour. Want to send one transmission per minute? You'll have to get your transmission time down to 0.6 seconds. And your transmission speed is inherently linked to your data rate, and by extension your signal range.
There's no one-size-fits-all solution possible here. Either the user has to give it some information about their specific use case, or it'll have to stick to the absolute most pessimistic limits.
The ETSI document actually does allow higher duty cycle if the radios take anti-interference measures. Some countries unfortunately have "harmonized" but skipped that part. Theoretically only a dumb transceiver (that can utilize only a single channel) has to limit duty cycle that low in those bands.
Maybe ok for your garden camera where the authorities just don't care. But no go for any industrial usage.