Its all relative.
My big bike is a TU250, 340 pounds wet.
My little bike is an XT200, 260 pounds (or less).
The DR650 was fun with the power and torque, but I sold it after getting out of the hospital.
The motor on the 1200 sportster was fun, the weight and poor suspension was not.
Fun can be had on any bike, but I figure I do not want to end up in the hospital again or worse, plus I like pushing small bikes HARD.
Push a big bike hard, and it can end badly.