Heat for heat's sake is for occasional fun. Like vodka jelly or something. you're right, untrammelled use overpowers flavour. The correct chilli should complement a dish's flavour, hence scotch bonnet would be a disaster in a thai green curry. The trick with the heat is to get a decent buzz without ruining the dish, wel, that's the trick for a chilli-head anyway.