[Feature Request] Backport "VideoCommon: enhance wildcard support in hi res texture lookup"

[osharp0]

Currently, some HD texture projects (such as, RE Seamless project, https://www.reshdp.com/re2/) aren't functioning correctly in dolphin libretro core, because this wildcard enhancement feature isn't backported: https://github.com/dolphin-emu/dolphin/pull/9711

With the wildcard enhancement, many texture packs will be supported properly. The code changes seem small and straightforward, so this looks pretty cost-efficient.

Please let me know what you think. Thank you!