It seems very few that transfers end up contributing (in football anyway, basketball is totally different) even if they go to a lower level.
UNI had a transfer from Southern Cal that was a Top 5 WR...he was a decent WR, but not a focus of their offense. Name was Whitney something. A few years back.