I have found errors in VSP. A few people with whom I have corresponded have also found errors. Some objects are missing from the VSP; some non-existent objects are included.
Unfortunately it appears that it may be difficult to get errors corrected.
How excited to get is a matter for you to decide. What I do is always to check with the MPC asteroid calculator and to compare with the DSS images available through Aladin. If something new passes both those tests, then I get excited and ask for confirmation. The last time this happened it turned out that the suspected transient was actually a ghost of a bright star. The slightly embarrassing details can be found on my personal collection of images here on britastro.org.