In my experience the reason why one learns expensive lesson (happened to me also and it was the only case when I had to respin board due to wrong footprint) is

In my experience the reason why one learns expensive lesson (happened to me also and it was the only case when I had to respin board due to wrong footprint) is that you just end up thinking "this is too simple to get wrong". I had my share of shipped products with extensive manual rework, professionally made bodge boards and respins of 3ft square boards (which there were enough that the board does not use letters for revisions, but timestamps of when the gerbers were exported), but it usually involved questionable component choices and attempts to route what should be controlled impedance diffpair across 10s of centimeters of two layer board and cheapest connectors we could get, but really the only case of respin due to wrong footprint involved measly BC840 NPN transistor with rotated pinout... (on the other hand hand soldering the transistor involved at the 45deg angle solved the issue for first batch which was hand assembled anyway :))