The key thing to remember when you ask these questions is that the parts make up a circuit. What you use and where makes up a greater whole. Just replacing all the parts from one manufacturer with those from another like the video you posted isn't always the answer. In some cases it will certainly make an audible difference, others hardly a thing at all.
To answer your specific questions:
- Orange Drops can have a certain body and edge, but remember they have several series of caps with different compositions and characteristics.
- The blue and green 470pf caps I believe you are referring to are all ceramics as well. Ceramics can add a grainy-ness or grit to the sound. Remember these are guitar amps, not hi-fi. Those terms are desirable when discussing guitar tones. An amplified guitar sound with very little THD would be flat and uninspiring. Much like plugging your guitar straight into a channel on a PA mixer.
- Silver Mica can be considered detailed and bright, but it depends what you are comparing it to. My advice would be to only use them in parts of the circuit.
- Carbon Comps largest contribution to an equation is they tend to distort in a pleasing way. They have high drift, pulse power, variability and excess noise. But remember what I said in the ceramic cap bullet: THD is part of what makes a circuit interesting. To see these characteristics at their most extreme, they would ideally be used in parts of the circuit where the voltage is highest.
It was pointed out in another post that anyone inquiring about these topics (I believe it was in reference to the tone stack) should take the time to map things out and actually learn the circuit. I strongly encourage that. It will give you a much better educational exercise rather than a free lunch of sorts. Those of us in the know spent many hours learning this stuff, conducting our own tests and forming our own opinions based on the results. I have no issue providing guidance to someone that spent the time and put forth the effort but hit a brick wall.