Beyond the amazing power of its upgrades, this level 0 creature can act as a resource generator. Uncanny Growth has no limit to how many growth it can put on at once, meaning you can turn each point of success into a resource.
Looking at the cost analysis:
Cost: 4 actions (to play, get event, investigate, get resources), 2 resource cost, ~2 cards to commit.
Benefit: 1 clue (~1 action), 6 resources, 1 health/sanity.
Result: -3 actions, +4 resources, -2 cards, +1 health/sanity
which is not worth it, compared to other cards that generate resources.
For a big-Money deck that focuses on high skill value, it might be worth it. For instance, in Jenny, who can take Streetwise, each cycle (get Uncanny Growth, play Uncanny Growth and boost with Streetwise, get resources from Myconid) would increase her resource pool by roughly 50%. Though, woe to the person that draws an autofail (maybe bring Justify the Means?).