I have no idea how you botched up your link like that, reminds me of a time when ShadowHog linked to the cover of Sonic 3D (E) instead of Sonic Stadium.
That being said, there's not a _lot_ of uses for translucent main textures other than just cool effects, especially since they're limited by the size of the main texture itself. I wish there was a way to make the main texture tile across the whole wall.
Translucent walls could most effectively be applied to make windows where you don't need the player to go under or over them. See Midnight Abyss, or just about every other room in Egg Rock 1 and 2.