Diffusion Models as Network Optimizers: Explorations and Analysis