Heavy-tailed targets and (ab)normal asymptotics in diffusive motion