Points Counts of Moduli Stacks via Motives and Cohomology