Is solidworks standard overkill too?
Easy to confirm that Catia and NX are over the top because they’re Enterprise level tools. Not possible to simply categorise mid-range products.
I suspect a case of “Beginner Feeling His Way”. No shame in that, we all have to start somewhere. The term “Model Engineering” doesn’t narrow the field because the hobby ranges from folk pushing CAD to the limit down to chaps who don’t need it at all.
The best way to choose tools to identify what they need to do. Write a list of the jobs you need CAD to do, then use the list to narrow choices down, either by reading specs, or asking here. The forum is much better at answering specific questions than generalisations lacking detail.
Looking at the example below, what do you want to model?

Is it the engine, the buildings, the street furniture or the figurines? If the engine, then it’s useful to CAD model it as dozens of individual parts in an Assembly.
Is photo-realism important?
Think about support. CAD being quite difficult to learn it’s good to have help. Solidworks isn’t well supported on this forum – not enough users. Alibre, FreeCAD, Fusion360 and SolidEdge all have active users who can answer questions. Alibre is particularly well supported at the moment because the company are actively promoting their product.
Solidworks sell Standard, Professional and Premium versions: if Standard doesn’t cut mustard, upgrade it. Fusion, Alibre and others do the same. I get on well with the community edition of SolidEdge because it’s almost the full-product, no limits. SE is harder to learn than Fusion360, but F360’s community edition has a 10 part limit that’s too low for me. Freebie F360 is great for small projects, but not if you exceed the limits.
Budget may be the deciding factor.
Can you explain what you expect of 3D-CAD? If not possible at this stage of the game, I suggest starting with paper and pencil. After doing that for a while, what you need from CAD will become more obvious, and it may not be needed at all! Alternatively, choose one, preferably free, and get stuck in. Learn from the experience, and upgrade or switch products as necessary. All the CAD products mentioned do most of what most Model Engineers need, which is wonderful until we find we are special.
Dave