Also consider a gravel bike.
Currently, it's my favourite type of bike. You do not have to stick to paved roads, which are infested with unattentive/aggressive drivers.
A gravel bike with wide enough tires is a good compromise between off-road capabilities and speed.
If I had decent mtb trails near my doorstep maybe I would use the mtb more often.
My road bike does not see much use anymore.