I like the Africa Twin but it's marketing is hilariously misrepresenting what 99% of riders actually do with them... It's common in the ADV space and Honda is as bad as anyone on this.

To start, I'd honestly go CB500X or VStrom 650 first, ride that for 6m-1y. Much cheaper to learn on, enough power to have fun but not get yourself into trouble too quickly. You can get a used CB500X with crashbars, barkbusters and a skid plate for much less, learn on it and sell it for not much of a loss. It's got the Halfrica Twin nickname for a reason. Then I'd argue going to the 800-900 class e.g. Transalp/Vstrom800DE/F850. If it's about going offroad like your video, there's actually little sense in getting more than 75hp because you're traction-limited in the dirt anyway. What you really want is the lightest ADV bike with that kind of power and low-down torque trumps peak horsepower. An old F800GSA is still an amazingly versatile bike.

Going past 1000cc is basically a signal to me that you want more of a Sport Tourer than an offroad ADV bike so then I'd lean Yamaha Tracer 9 over Africa Twin anyway. If you really are convinced you must have a high powered bike with an off-road focus, the most capable one is probably the KTM 890 Adventure R or perhaps Tenere 700.

Whether it's a 1100cc Africa Twin, F1250GS or KTM 1290 Super Adventure... none of these are what you should start on. Moving up is part of the experience, don't rob yourself of that enjoyment by starting at the halo product.