I use awk sparingly. I prefer sed where it can be used. Awk comes in handy when I need to parse or create a csv.

I have one script I use to enter client data into estate plan documents that relies on awk to read the csv containing the data fields, sed is then used to make those values into variable in typst and to add them to each file at compile time. On average, a csv for a plan containing fields for four people (e.g. parents and two kids) will generate around 800 variables from 18(x4) or so fields. So it comes in handy. Saves me hours.