I personally use Cakewalk Sonar x3 with a focusrite pro 40 - and its great. I know pro tools pretty well as well - it has different advantages.. I feel that most DAWS offer a different set of advantages etc.

As far as latency goes - thats ironically strictly a hardware issue. If your DAW had its Druthers...(haha) - there would be no latency ever.