There is no rule stating that RPGs have to have static gear. And it's a boring design anyways.
I like the idea of having RNG + a way to control it. So the best possible gear system that I have ever encountered in any game I have ever played is...
PoE with harvest crafting.
The way it worked was:
You get completely random bases, chance of getting something decent was low, chance of getting perfect one was close to winning a milion dollar lottery.
BUT
Thru normal gameplay you get currency that is able to do all sorts of wonders with these bases. Remove stats, reroll stats, add new stats, reforge sockets and so on.
Basically with some commitment you could get some decent base to work with, and with currency you could turn it into a masterpiece that is absolutely perfect.