Think about giving someone a generic gift card without any other information vs. "Hey, I know you're looking to get into art but honestly I have no idea what type of supplies you want, so here's a gift card to buy what you want from xyz art store".
I know when I was a kid getting a $50 gift card for some toy store that sold video games was the best thing ever. Your Aunt may have good intentions but she probably doesn't know what games you like but you sure as heck appreciated the gift because it translates to something you really like that was enabled by the gift giver.
I think the card being specific to 1 store also really helps personalize the gift. You can be sure the person will enjoy it instead of maybe feeling guilty about how they should really use it for every day living expenses.
The only time I use gift cards are when it needs to be reimbursed as a business expense.
Personally as a gift receiver I much prefer receiving things that I couldn't have gotten myself, and preferably edible. Simple homemade desserts are great.
I think the sweet spot for a gift is something I would enjoy but would be unlikely to buy for myself (or in the case of experiences something I normally wouldn't do often), as you pretty much said. But a safe way to achieve this IMO is something like a gift card to a nice restaurant or a spa. Of course you still need to know your target though.
Kind of reminds me of the Netflix problem, the large pool of choices can make none of them seem particularly exciting.
But now I think that was a foolish dismissal of social obligation. It really is the act itself that has the most significance, less so the content. To wit, the article's advice that in most cases, cash is fine.
I'd rather use them as a last resort, for people I don't know so well.