My approach to decoupling my circuits is to take out my 100nF salt shaker and to sprinkle liberally over the board.
https://www.allaboutcircuits.com/technical-articles/x7r-x5r-...
In my experience, 0402s are the breakpoint on the curve.
0603s are large enough that there are a couple of cases where they're kinda marginal due to size (inductance) and the size gain isn't quite enough for things like QFN packages. 0402s almost never have the issue. 0201s aren't enough better that they are worth the extra grief to deal with unless I'm on a really constrained board, and I'm only letting an assembler do the board (nothing by hand from me).