We have a say in French. TGCM. Ta Gueule! C'est Magique. Or in English. SUIM. Shut Up! It's Magic!
All We can do is assume that there is an unatainable logic, for us mortals, That would explain the whole thing. Unfortunately, we simple mortals, can only guess at the reasons. The most plausible one is that the canon and tentacule actually create or summon something tangible while the others are insubstiantial spell effects that takes substance (if at all) only when the spell actually attack (spiritual weapon) or stays insubstantial by nature (flaming sphere).
As with everything in D&D, the choice is yours to interpret. Your game, your rule!