Is Dynatrace 'aware' if CPU/Memory high utilization is worth it or due to some issue?

When Dynatrace alerts, it will include the root cause. If it’s like Garbage Collection, it will probably mean “bad”, but it might be to a long query as you say, and the root cause will identify the query, which might be “not that bad”. Not all problems will have a root cause, but I can guarantee you that should be the first thing to look for…