I an not quite sure how they justify a 100dB DNR ADC as 24 bit, but whatever.
C0G are basically electrically blameless, I like Murata/TDK/Kemet, or if feeling flush and wanting low values, ATC porcelain parts have some nice features.
Murata have a spectacularly useful 100nF 1% C0G in 1206 that is IMHO just perfect for audio filters and the like at low impedances (Yea, 100nF!, C0G!, it was a good day when that came out).....
X5R and X7R are class II dielectrics, use for decoupling only, and even then not on critical reference rails, NOTE, you need to read the real datasheet for which ever parts you are using, especially in smaller packages the reduction in rated capacitance can be a proper shocker, think well over 50%, and they also suffer with time and temperature, Y5V parts are usually even worse! All the proper vendors have tools for this, Murata for example has their simsurfing tool that tells you what they parts will really do, but all the top tier have this data available.
Murata, TDK, Vishay (In there many forms), Kemet, are all top tier vendors for MLCCs, (Add ATC if RF is your thing, and CDW if you want high voltage and mica parts), but as always READ the datasheets of the series you are planning to use (Normally there is a short form one that the distributors have and a more serious one on the vendors web site).
Be careful about physically large MLCCs especially if hand soldering, and read the app notes about board flex and cracking in MLCC parts, some variation on 'soft term' can be worth the extra expense if you must go 1206 or bigger.
For electrolytics everyone has a view, I like Panasonic, CDW, Chemi-con, but you MUST read the datasheets and do the lifetime calculations (The equation for which does actually vary from part to part).
If doing real precision it is worth mentioning that resistors are NOT blameless, and in particular that thick film SMD parts can have a disturbing voltage coefficient, thin film are generally better that way.