Which Camera is most recommended for which Application?

This is a question we get quite a lot - find out all the answers here!