I know it says that, however, clearly SB, CoC, BHs, Eyebite, don’t follow that rule.
There is no way you can say those spells “affect only [the caster]” and uphold what their actual effects says.
My best estimation is Specific vs General. The specific rules of those spells, trump the general rule on Range: Self spells.
None of those spells “effect only you [the caster]”, so that can’t apply, unless you’re also trying to argue all those spells only ever damage the caster.
I don’t particularly care if SB can be dispelled or not by targeting the caster, but claiming SB ever only effects the caster, as well as similarly claiming the same for Burning Hands, Eyebite, CoC, etc, it’s a horrible logical argument.
You can either accept Range: Self spells only ever target the caster, or they don’t necessarily follow that rule. But if you don’t accept they necessarily follow that rule, then that rule cannot be in and of itself evidence that a Range: Self spell only affects the caster, particularly when that spell specifically states it creates an object that clearly can effect others.
I would say BHs and CoC NEVER target the caster, which is clearly in direct opposition to the quoted rule.