Since you don't like me doing the copy/paste thing... Copy the above link and read his letter to Madison from 1787. It wasn't just the failure to include a BoR, but lifetime Presidency and other matters as well.
Several of his letters after this contain further disapprobation.
Hardly supportive as you've suggested.
It's clear that he felt that the Constitution need amendments and he was pretty unhappy that certain aspects of the Virginia constitution were not applied to the federal Constitution.
But he did not, like the Anti-Federalists, oppose the basic structure of the government contemplated by the Constitution. He did not object to the existence of the Senate, or a Supreme Court or a unitary executive, and he was an advocate of national commerce.
And, as I said, every supporter of the Constitution (except for Madison) was dissatisfied with it in some particulars.