It is true: calibre does not currently support connecting the Nexus 7 using cable. You need to use some other method. One is the one you mentioned: dropbox paired with calibre's connect to folder. Another is
Calibre Companion. Some people have used sftp, and some people use calibre's web server.