This is an article I recently refreshed the content of. Top 10 reasons your PCB lets out the magic blue smoke monster. Anything I missed?
I’d add that most any power-related IC can have troublesome variants. Not only linear regulators, but switching regulators, supervisors, load switches, etc.
Lots of LDOs out there with flip flopped pinouts.