Personally I always get excited by process automaton. Been a minute since I've done any VBA but my favorite projects I used it for were probably:

1. Bulk updating CAD models and drawings as part of rebranding. (Solidworks)
2. Interacting with a 5250 emulator (AS400) to automate the data entry/extraction I was doing

Stealing this for next year's family Christmas DnD session!

Oooh thanks for the tip. Just learned about ^typo^correction that way!