Of course he did. And of course guess who else did?:
Mr. HAMILTON ... He was strenuous agst. making the National Council dependent on the Legislative rewards of the States. Those who pay are the masters of those who are paid. "
Madison and Hamilton were united on this central idea: that a national government should be created with supremacy over the states. And Hamilton is quite right: He who pays the piper calls the tune. That is why he and Madison predictably argued for the nationals to pay themselves from their own treasury.
For good or ill, they clearly did not trust the league of states, and wanted a single, unified republic. The states would remain as subordinate agencies, and the nationals would possess supreme power, including a negative on all state constitutions and laws.