Scale types other than the Major scale lend a completely different flavour to a melody, because of the different set of notes and intervals they provide.
While music can be written directly in one of these scales, they are also often used as the framework for improvisation, the playing of a spontaneous melody line over a backing chord progression.