I have to say I'd rather keep it the way it is. It isn't that distracting for everyday use if the box in the Tag Info window shows "Varies" (I would generally only see that when I'm actively tagging files, and then I'd just fix it if I'm feeling anal).
However, I'd have to turn the Tiles View off if I suddenly had three-or-four choices for "the beatles":
beatles, the
Beatles, the
Beatles, The
beatles, The
I'm a consistency nut too, but only when it doesn't hamper functionality.
EDIT: I should add, the problem with wholesale ignoring of case in both windows is that it becomes very difficult to correct the case if you
are feeling anal. For example, fire up iTunes and try to change the case of an "Artist". Because it ignores case, it doesn't see your change as a change and doesn't apply it to the tracks. There's really no way to do it (which drives me bonkers on my Macs).