Point Counts of Moduli Stacks via Motives and Cohomology