You can catch it with a footprint review. List all your new footprints or old footprints assigned to new parts, and have someone else check them against the datasheets. Or if you ever have the good fortune to work with a very good layout designer, they will check things like that for you just to catch you out.

I haven't managed to design a pcb without finding an issue in the first run.

Shoutout to OSHpark's prototype service. Something like 5 bucks an inch and you only have to toss out 3 if you find a fault.