You can't speak of magnitude of effect in isolation. This is a common source of confusion because we often encounter the term in a discipline-specific setting, but the hand-wavy discussions quickly lead one to speculate whether there is literature on a seemingly abstract biostatistical topic of "magnitude of effect".
But no, the literature or scientific setting itself is the basis of deciding what effect sizes are. Predefining these effects is an important point of study planning, and content experts should speak about the state of knowledge to form these definitions (or else people are just blabbering nonsense). What's lacking is an explicit conversation to settle what a meaningful effect--and consequently small or large effects--might be.
That said, the notion that a RRR has to 50% or greater is somewhere between hysterical and offensive. Written by someone clearly out of touch epidemiology, if not reality. Go ahead and read a few abstracts of AJE's most recent publication to find examples to the contrary.
Some considerations:
The burden of the disease or condition in question. "Burden" is intentionally loosely defined here and is a catchall for prevalence, mortality, cost, severity, QALYs, disability, QoL, etc.
The promise of an intervention or treatment both in terms of its effectiveness but also in terms of its cost, availability, etc. Other treatments, and also the lag, harm, and specificity of indicating the treatment (e.g. do you need a blood panel, wait for weeks without treatment when the off-the-shelf alternative could have been used sooner, better, and for less?)
Lastly, the design of the study. Sometimes the RR is a biased estimator. Not a problem, but we have to consider that sometimes in exploratory analyses or biased samples, we have to interpret things cautiously, though we'll still proceed with confirming strong or promising signals.
As an example, fish oil has recently famously been "discredited" as beneficial to heart health. They followed a cohort of 5,000 people and 300 deaths occurred, and a hazard ratio was found to be 0.9 just straddling the 1.0 null in the 95% CI. Now, fish oil is dirt cheap, not toxic whatsoever, and if I saw those results, I'd wonder if the study was merely underpowered. A 10% reduction in mortality is a big deal. If it was a $10,000 medical procedure to transplant stool, I'd be more inclined to say no.