It is hard to tag a 'best' capacitor. There is a best capacitor for a particular job. Some apps need good temp stability, some need low ESR, some need low leakage, some need low parasitics inductance, some need low dielectric absorption.
Mica is pretty stable, low ESR capacitance but has relatively high parasitic inductance compared to ceramic. Don't see Mica too often these day due to high cost. Ceramic dielectric does not give up all its charge (dielectric absorption) so you don't want it for a frequency synthesizer loop filter. High K dielectric ceramics have low Rs and high capacitance for unit volume but capacitance can be a function of applied average bias.