Nice video, looks fun. Where is that? Beach riding isn't an option in southern BC. Is that yellow bike legal on the road?
No doubt the dual sports would be better. But in the world of compromises, one will suit someone better than the other. Spend 25%+ of the time in the dirt? Get a dual sport. Spend less than 10% of the time in the dirt? An adventure bike (Versys-X, V-Storm, CB500X) will be more suitable.
I don't have a hatred towards dual sports by any means, I pretty much hogged them in riding school. My only gripes with them is that the seat isn't the most comfortable thing to sit on for hours and hours of touring (the bigger ones are), none of them come with ABS braking in Canada (CRF250L Rally in the USA gets it, makes no sense why Canada doesn't), and -- Honda specific -- why that bright red "look at me I'm a dirt bike rider!!!" colour scheme?
Speaking of dual sports, I noticed that Yamaha no longer lists the WR250R on their website.