35mm films like Ektar or Velvia/Provia have resolution comparable to a modern full frame DSLR, so if you're happy with the resolution of that DSLR, you can likely be happy with film.
As for technical limits, depends on your standards really, same as digital.
For me, the strong points of 35mm is small size of cameras, for other uses, I prefer medium format.
For "industry", I would imagine it varies wildly. Some publications are happy use to mobile phone photos, and some will demand perfection, and there will be everything in between.