When starting out, take that weekend course your local college offers - and try all the bikes in a controlled safe environment. I was shocked how much I didn't want a sports bike - the posture and low speed maneuverability were horrid. I also didn't like cruisers personally, didn't feel in control leaning back. I turned into a lifelong standard posture guy - whether city bike or adventure or dirt/supermoto... But point is, find out what feels right for you, rather than get a 750cc superbike as your first ride based on specs or review or what you think may work well.
I had fun going full throttle redline on... My cbr125, back in the day:D. More so than on some twitchy overpowered bike where I feared touching the throttle.
My instructor claimed the DMV had done this on purpose to encourage people to take the safety course, how they can't force people to do one by law so this is how they got around it.
Not surprised in the least that there are so many accidents.
During training we had to switch motorcycles (we started on 250cc, then after a dozen hours moved to 600cc which is required by Polish law to pass the exam).
I have felt comfortable on 250cc but moving to 600cc felt like I had to learn everything again from the start.
On 250 (140kg?) I could throw my weight around and cause motorcycle to do stuff while the same no longer seems to work on 600 (210kg?).
Overall I feel better and safer on 600cc because at highway speeds it does exactly what I need it to do and place myself exactly where I want without feeling that it is overpowered and that slight mistake with the throttle is going to cause me to loose control of it.
I tried a dozen different motorcycles from 125cc to 1000cc before I made my final choice.
One disclaimer is that I am rather cautious driver/rider. As an example I never drive/ride fast in relation to other drivers. I may ride faster but only so much so I still am able to react if they make something stupid. I also spend a lot of effort learning to drive/ride safer.
When it comes to pratical matters I think that for safety it doesn't matter much how large your bike is, as long as you are properly trained. 125cc or 1000cc, your prospects in an accident are roughly the same.
Smaller bikes (125cc or less) may offer better handling if you are not well trained and you panic but on the other hand they might be less agile in traffic where it is important to constantly place you away from blind spots of other drivers, etc.
The only danger comes from speed and acceleration. But if you are an adult and can restrain yourself to safe speeds I don't think larger motorcycle is less safe.
What I mean is that it is not the size of the motorcycle but the driver that causes it to be unsafe. And unsafe drivers may prefer to choose larger motorcycles because it allows them to ride faster.
1. As a sibling said, there's the issue of weight. If you're inexperienced, it WILL bite you in the ass. Especially since the engine being very powerful and having great brakes, when "just starting slowly" it won't feel heavy. Hell, mine gives you the feeling it stands upright on itself. But try braking a bit harder while maneuvering and getting it tilted, and you better expect the 300 kg to want to get down.
2. As per 1, powerful engine + heft + (usually) great suspension give you a bike that feels very, very safe. Plus the torque from way down low never seems to quite "rush" you since you don't have to rev it. So it gives you confidence. Except that even though you don't feel like going fast, you actually are going fast. So you get fairly quickly in deep water, and everything is great while the sea is calm. The sea floor is right there! But you never know. Ride a bit too fast in a turn, and you better hope there aren't any trees around...
Lost count to seeing scenes like kids on H2Rs "crashing" into something at like just above pedestrian speeds.
It takes a lot of skill to drive a powerful, and heavy motorcycle. It's definitely should not be your first, or even second machine.
I'm myself on two-wheelers for 15 years still feeling that I am about to fly off a seat even on a relatively tame 300CC scooter.