Us commercial designers often have access to review procedures (semi/automated DFM (design for manufacture) checks), which is a great help, but also still quite limited, depending on just how fully featured it is of course. (For example, the one I use often, is really limited to checking footprints and spacing, and only those that are in the database. Anything not in the database, basically comes back with a note "we couldn't tell, check this manually".)
There is value in mitigation. Put 0-ohm jumpers on your RXD/TXD pins, you'll confuse them eventually and it's an easy hack to swap them back.
MCU pins with source-termination resistors are handy test points and for rewiring.
Use easy-to-handle parts (0805 chips?), leave enough space between components that you can hand-solder them (or whatever processes you have access to).
Use relatively large pads, so you can hand-solder them, or put on alternate parts if needed (say, replacing an 0805 resistor with a SOD-123 diode, or a 1206 chip?).
Prefer general-purpose parts, in widely available packages (SOT, SOIC, TSSOP..), and check the pinouts not just for your preferred parts but check for possible pin-compatible substitutes as well.
Download IPC-7351 (preferably a newer version (a or b), but any will do), read and understand how leads and pads are dimensioned, and check your footprints against them. Tweak the dimensions to suit your process (e.g., extra toe length for hand soldering).
As for personal review -- when you don't have access to, or budget for, any of these services, you're just checking it yourself -- that's down to the user, obviously. Some people are great at spotting a needle in a haystack. Often it takes a lot of experience to spot these sorts of things. You're literally inspecting
thousands of objects. Expect to make mistakes, but also take your time, and interact with your design. "Handle" it, as well as you can with a CAD model; generate 3D views, get a feel for how the connections are routed in space. Check your memory of the part pinouts, top and bottom; recheck them against the datasheet.
Got a bullshit datasheet that's showing the footprint backwards, or not labeling things, or the drawing is full of fuck? Ask, maybe someone has experience with that part, or can look it up in a database.
Personally, I do a lot of faffing around on PCB layouts, idly shoving traces, prettying things up. This mitigates the fatigue of staring at thousands of objects, and provides a different way to interact with and inspect them. This also gives me the time and perspective to contemplate other issues, like circuit strays, EMC performance, DFM, DFT (design for test), and so on. (Besides the value this faffing actually generates, I do -- if I do say so myself, and based on others I've seen -- do the actual layout work very quickly, so I have plenty of time to spend in this way, compared to the average service.)
Tim