You are absolutely right about this. My parents had 40-year careers as litigators, and in every case they tried the judge would instruct the jury that there was no difference between circumstantial and direct evidence.Everything that isn't eyewitness (or "direct") testimony is circumstantial evidence. Yes, that includes fingerprints. As we should expect, in this modern era circumstantial evidence usually outweighs direct evidence.
It is a lazy convention of screenwriters and novelists to use "circumstantial" as a synonym for "weak evidence". In the case of DNA, there's nothing weak about it.
My father's favorite way of reminding the jury that a circumstantial case can be quite compelling went something like this:
"Suppose that you come home in the evening and observe that the ground is dry. You go to sleep and when you wake, you observe that there is snow on the ground. There is no direct evidence that snow fell between the time of your first observation and your second, but you are very confident that it did. You can reasonably infer it from the circumstances."