Assessing the prospects for robust sub-diffraction limited super-resolution imaging with deep neural networks