1. Losing +1 modifier for main spell-casting stat is not "shooting yourself in a foot". You massively overstate the importance of having a +3 instead of +2. It's more visible for martials, but it's never character breaking. 16 int wizard being great and 15 int wizard sucking is just not true. In cases when it would made a massive difference you probably shouldn't rely on DC spells anyway (+1 to DC matters a lot when your chance of actually beating their save is low, meaning you probably should do something else). In 3.5e or Pathfinder the difference is a lot bigger since a lot of class features scale with your main stat, 5e is a different beast.
Yes, of course it is shooting yourself in the foot. A higher number has an impact. That's a fact, it's not in dispute at all. You're just arguing that being shot in the foot isn't as bad as I think. It's irrelevant that other systems have shooting yourself in the foot be much worse. We're not talking about other systems. We're talking about 5e.
3. Floating stat bonus doesn't really prevent you from feeling penalized. Why would you play a High Elf or Tiefling wizard when you could play a Shield Dwarf with the same stats and additionally use medium armor. Why would you ever play any other race than Drow as ranged character? That darkvision increase is incredible. Why would you play a frontline that is not Gold Dwarf for that toughness. Or Barbarian or Champion that is not a half-orc...
It doesn't fix a supposed problem while ruining race identity,
Because if I want to play as a High Elf or Tiefling wizard, I want to play as a High Elf or Tiefling Wizard and not a Shield Dwarf wizard. Those are different characters, even though they're both wizards.
You talk about how floating ASI's destroy the identity of races? Where the +2/+1 goes is the LEAST interesting thing about a race.
My idea for a pen-and-paper Halfling Wizard doesn't start out by first taking 1 level in Artificer before going full Wizard, even though that would be more mechanically advantageous. Based on that character's personality, history, and circumstances, it does not make sense for them to take a level in Artificer, so they wouldn't do that.
***
By continuing to ignore my question about how your fun would be impacted, it proves you have no answer. That shows that my argument is correct.
