For your particular use case Eye Fi might be a solution. I'll just use N900 camera and wait until TransferJet (or similar technology) is a standard.