This well-received answer to Why does the same electron transition release photons of different frequencies for some elements? begins with the following intriguing passage:
I am glad that you updated the question because it highlights a very common misconception. First of all the JavaLab Flame Test is completely wrong for both copper, calcium and many more salts especially the Group II and transition metal salts. Consequently, the NIST reference does not apply (see below). Secondly, it is a cruelty to science if a cartoon flame test is being shown instead of the real flame test. Search Youtube for real flame tests.
Rather than each of us search YouTube for it, I think it would be great if a short explanation of what chemists would consider a "real flame test" were captured forever in a Stack Exchange answer. So to that end I am asking:
Question: What is the difference between a "cartoon" flame test and a "real" flame test? How do chemists do flame tests correctly?
The next paragraph mentions a "pocket spectrometer" that one can actually make from a DVD (this is fun, I've tried it on various neon lights but never a flame) and there are discussions of spectral databases in the question and answer(s) there. Are these necessary ingredients of what a chemist would consider a "real" test?