Fuel foaming is sort of like flutter - It will only happen if all of the conditions are right.

In your case, the unbalanced prop was enough to cause it - but that alone should show you that it is not a myth.

I have seen it happen on several airplanes, it's no myth.