The different ways a tire can be unaligned

Crazy negative camber is just a style thing. You can see fairly aggressive/negative camber on racing cars, and on a track it serves a purpose, but even in those cases it usually much milder than what I think you're referring to .

Standard street performance is around 1-2 deg negative camber, an experienced eye can tell when looking at the car from the outside but it's not super obvious. Aggressive track camber is around 3-4 deg, that's getting a bit more obvious to the naked eye, but still looks fairly normal. The cars you're talking about with like 10+ deg of camber, where the outside of the tire isn't even touching the pavement, is just the owners making their car handle like shit and burn through tires every 1000 miles because they think it looks cool.