La Roche-Posay Anthelios Ultra Comfort Cream SPF 50+ Versus Estée Lauder Perfectionist Pro Multi-Defense Aqua UV Gel SPF 50

This ingredient gets a bad rep because it is irritating and drying due to its astringent property. Astringents draw out natural oils in tissue to constrict pores and dry out your skin.

However, alcohol denat. is not all that bad.

Due to its low molecular weight, alcohol denat. tends to evaporate quickly. One study on pig skin found half of applied alcohol evaporated in 10 seconds and less than 3% stayed on skin.

This also helps other ingredients become better absorbed upon application.

Studies are conflicted about whether this ingredient causes skin dehydration. One study from 2005 found adding emollients to propanol-based sanitizer decreased skin dryness and irritation. Another study found irritation only occurs if your skin is already damaged.

Small amounts of alcohol are generally tolerated by oily skin or people who live in humid environments.

The rule of thumb is this ingredient will probably not affect your skin much if it is near the end of an ingredients list.

One thing to note:
People with ALDH2 (aldehyde dehydrogenase 2) deficiency may experience skin irritation from continued alcohol use. About 8% of the world's population have this deficiency.

The Cosmetic Ingredient Review Expert Panel has determined denatured alcohols to be safe for use in concentrations between 0.05% and 12% (depending on which denaturant is used).

Also...

This ingredient has antimicrobial and solvent properties.

The antimicrobial property helps preserve products and increase their shelf life. As a solvent, it helps dissolve other ingredients.

Look for formulas that contain glycerin, hyaluronic acid, or panthenol if you want to offset any drying effect.

This ingredient will trip away your skin's natural oils/lipids that help it lock in moisture. This can worsen dryness, trigger eczema flare-ups, and aggravate rosacea.

Be sure to patch test any product with this ingredient if you have dry or sensitive skin, eczema, or rosacea.

The Cosmetic Ingredient Review (CIR) Expert Panel evaluated it (along with 22 other acryloyldimethyltaurate polymers) and concluded it's:

Due to its large molecular size, it sits on the surface of skin rather than penetrating it.

Studies have found that avobenzone becomes ineffective when exposed to UV light (it is not photostable; meaning that it breaks down in sunlight). Because of this, formulations that include avobenzone will usually contain stabilizers such as octocrylene.

However, some modern formulations (looking at you, EU!) are able to stabilize avobenzone by coating the molecules.

Avobenzone does not protect against the UV-B range, so it's important to check that the sunscreen you're using contains other UV filters that do!

The highest concentration of avobenzone permitted is 3% in the US, and 5% in the EU.