How does the acidity level of various types of vinegar, such as balsamic, apple cider, and red wine vinegar, affect their flavor and use in cooking?

How does the acidity level of various types of vinegar, such as balsamic, apple cider, and red wine vinegar, affect their flavor and use in cooking?