In Theros block Limited, this card became well-known as "Surprise Centaurs." When this card was first released, there was a slightly more powerful card that did something similar called Advent of the Wurm from Dragon's Maze. That card is 4 mana for a 5/5 Trampling Wurm. While Advent of the Wurm is probably better, this is pretty good in mono-Green.
Fated Intervention is definitely a solid Limited card and playable in token-abusing Commander decks. Many Trostani, Selesnya's Voice and Rhys the Redeemed builds have found a place in their token builds for Fated Intervention. The Scry is a nice little bonus, but most of the time it's played on an opponent's turn, where the surprise creatures are a bit more valuable. Having two guys to block with out of nowhere is definitely relevant.
Even when Advent of the Wurm rotated out of Standard, Fated Intervention has only been a Commander-only card. The 5-drop slots in Standard were consistently been filled with more impactful cards. Sadly, the deck this card would most be at home in, Centaur Tribal, has never taken off. That's despite the support the creature type received during Theros block. But when Fated Intervention was played in Theros/Born of the Gods/Journey Into Nyx Limited, it was plenty good. And in a token-happy Commander deck, it can often find a home.