There’s an anime that kind of flips this around. Instead of an everyman who can use magic, the protagonist is someone born in the royal family but can’t use magic. Don’t know if this counts.