Does Insight Affect Difficulty?

Is it good to have a lot of insight in bloodborne?

.

What does Insight do in bloodborne?

Does insight affect frenzy?

Do you lose insight when you die?