There are a ton of RPG assets. It depends on what you need. There are environmental effects, models, dungeon sets, etc.
You must be looking in the wrong places. I wouldn't say most things are geared toward multi-player real time games and FPS, as many of the assets can be used for anything you program. The kind of game those assets sit in is up to the programmer.
I mean, without even trying, on the first page, I can find three assets that I would use in an RPG. A set of village buildings, a blacksmith forge set and a bunch of dynamic skies. So, yeah...depends on what you want to build and how you want to build it.