It's not always about the actual scale, it's how it fits with whatever rhythm is going on underneath. It's also not always within a scale (players frequently go outside) and even intervals of popular scales sound dissonant if played together.

If you want a dissonant sound, look at diminished scales, or the locrian mode....