@thomask77 In specialized applications when you are targeting narrowband noise at a specific, known frequency? Yes, you want to match the cap (including mounting parasitics) to have the lowest possible impedance at that frequency which may mean going with a smaller value.
For general purpose broadband use targeting a wide range of frequencies, not so much. ESR/ESL tend to be close to constant for a given package size and construction (e.g. all Murata GRM series 0402s are likely pretty close) with only C varying. So more C will improve decoupling effectiveness if package size is kept constant.
Also keep in mind the difference between voltage *rating* ("the cap won't blow at this voltage") and the *practically usable* max voltage accounting for the C/V curve. Many higher valued MLCCs derate to 20% or less of datasheet capacitance at Vmax.
Higher C in smaller package size means higher electric field strength and a sharper C/V falloff. So a 470n will lose performance faster than a 100 as voltage climbs.