Hi Nil. Here's an online calculator to help you determine the amount of priming sugar you want to use. The Beer Recipator - Carbonation
Its based on the style of beer, as you said, so I don't think its so much about better or worse, rather than 'to style' or 'against style', if that makes sense. Carbonation isn't a defect, rather a difference.
I have had a beer that tasted a little harsh because of (I think) too high carbonation for the style. I would describe the flavor as harsh and minerally.