FUSE will provide Dropbox in a more integrated way than Windows (eg. terminal) and a cursory Google revealed some projects for Dropbox that do the JIT download you are after - they are old, but I wager still work just fine (an inactive project can just mean that it's complete).