Is it good or bad when a protein is denatured?

No.

Depending on what the protein is, the consequences could be good or bad for some particular individual. If you were about to be injected with snake venom and the venom proteins got denatured, that would be a very good thing for you. If the protein that's being denatured is your own hemoglobin, that's a very bad thing for you.