If your really serious about off road maps you can get the free topo maps or something paid like this from Garmin:
https://buy.garmin.com/en-US/US/p/1016You need a decent GPS with some open memory though. On my dual sport motorcycle I just use the simple 396 Zumo. I have used an old Street Pilot 2620 on my bikes though, those are dirt cheap and sometimes you can find a working one. But any recent Zumo will run those Topo maps just fine and you can use the open street topo and others too.
Here is an example of open source "free" Garmin compatible maps from GPSFile Depot for Canada:
https://www.gpsfiledepot.com/maps/country/caThe TOPO maps show all the details you need for off pavement adventures, dirt roads, hiking trails, creeks, lakes, rivers, back country camp sites ect..
You can also load Topo maps on smart phones too, but I've always used Garmin GPS units, thats all I'm familiar with.
