Here is a graph of planned infrastructure spending per person (by state) against the state unemployment rate. The spending doesn't look especially targeted. But would more targeting be better? Not if that meant less useful spending. The unemployment rate in Michigan is very high but that doesn't mean it's a good idea to spend a lot of money building schools in Detroit.
Fiscal stimulus would work better if the useful spending potential happened to be in the places where the unemployment rate was high but there's no reason to expect that to be the case. Every recession requires reallocation.
The ProPublica site maps/graphs infrastructure spending per unemployed worker against the unemployment rate but in effect that puts the number of unemployed people on both sides of the regression/graph and if there is any measurement error this can result in bias. The graph with spending per unemployed worker is similar to the above but with a slightly more negative slope.