RPG titlepack is only for Stadium maps. You can see maps specifically built in that titlepack by using this search:
https://tm.mania-exchange.com/tracksearch2?unreleased=0&tpack=RPG
Additionally you can see RPGs built in the base Stadium title, using this search:
https://tm.mania-exchange.com/tracksearch2?unreleased=0&tpack=TMStadium&style=4
These also should be able to be played in the RPG titlepack.
However, I've noticed some RPGs are built in the ESL/Competition titlepack. Those are only visible, and can only be played in, the ESL/Competition titlepack.
Here's a search to see those:
https://tm.mania-exchange.com/tracksearch2?unreleased=0&style=4&tpack=esl_comp
You mention Canyon RPGs as well. Those are played in other titlepacks or in the base title of Canyon.
Here's a search that shows all the RPGs built in Canyon, regardless of titlepack:
https://tm.mania-exchange.com/tracksearch2?unreleased=0&style=4&environments=1
On any map page, you can also expand the track details to show more details, including which titlepack the map was built it.
I hope this helps.