The Henry George Theorem also requires the public good to be local. Military spending for example is a public good that doesn't show up in land value increases.

Also in some cases (often with environmental spending) there is an external downward pressure on land value that is offset by an increase but you don't necessarily get an increase from the original neutral value if the pollution didn't occur.