I have owned multiple outfits that were tip-heavy enough that it was uncomfortable to carry them by the grip, because I had to clench my fist the whole time or the tip would hit the ground. The only alternative was to carry them with my hand on the blank, which was worse. This problem plagues high end "ultra light" fly rods, where all they do is strip weight out of the reel seat; carbon fiber hasn't magically become that much lighter, in the last 2 decades.
I don't think balance matters during casting, because you're waving something around in the air anyway. It does matter, to me, when actually fishing or walking; I hate having to clench my fist, just to keep the tip in the position that I want. It's also much more comfortable to maneuver a butt-heavy rod than a tip-heavy one. Hold a broom by the broom end vs. the stick and and tell me which one feels better. This shouldn't be controversial.