I've used it for recording music, combining some MIDI tracks with many audio tracks and samples. Once the audio system was set up and stable, working with Ardour was a pleasure and results were very good.

The main problem was getting high quality effects/plugins, paid or free. There are a couple, but in general life is much easier in this sense outside of Linux. That was 2-3 years ago, and hopefully things have improved since.