Best advice I can give is test ride. No amount of fancy equipment will compensate for hard use or abuse. Your skill in making repairs and recognizing the difference between hard use and abuse is of greater significance than the brand or model.

You can put aggressive tread tires on any bike but that doesn’t make it an off road bike any more than smooth tread on a mtn bike makes it a road bike.

Break it down. What will 80% of your use be, what size of tires do you want, how much weight will you be carrying, what surfaces will you be on ? Without some specificity you can get anything from a sport tourer with 32mm tires to a bike with shocks and 60mm tires.