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:
- Bulk updating CAD models and drawings as part of rebranding. (Solidworks)
- Interacting with a 5250 emulator (AS400) to automate the data entry/extraction I was doing
Was it a cool death though?