On Boards that I used to make & those that I contract out, I used a 0.8mm(31.496mil) hole for most parts (0.6w resistor, caps, 1n4148 etc) & 1mm (39.37mil) for (4004 diodes, 1W zeners etc..)
This always leaves plenty of room for consistent solder wicking to the top side pad.
However there are instances where I will make a hole a tight fit eg: single sided board & mechanically stressed (heavy) part, the close tolerance hole takes the stress away from the solder join.