While most fantasy fiction limits magic use to the main characters, fantasy RPGs have a whole economy built up around them. A default RPG setting assumes that the PCs are one of many heroes, which means towns are likely to hold retired spellcasters who might provide services or even sell magic items to younger heroes.
None of this magic economy really benefits the commonfolk, unfortunately. If a typical peasant makes only two silver pieces a day, he has to save up for a couple of months to even afford a simple cure light wounds spell, let alone something that could cure diseases or raise the dead.
The fantasy one-percenters, however, have a lot of fun options out there. Here are a few things somebody with lots of cash can accomplish in a typical fantasy RPG. I’m using Pathfinder as the rules default here, but most of these options exist in similar games as well.