Greatbow balance

Yes, that’s how it works, and that’s fine. It’s a near top-end strength build niche ranged weapon. Is it also an issue that the Nodachi and Barrett .50 cal can one-shot enemies? Obviously not, so it must be okay.

Nothing wrong with being a mechanical engineer, but you can’t grab an engineer, hand him an engineering problem to solve and say “It’s an easy problem, he solved it in two minutes! You need a harder problem!”
The greatbow is designed for builds with high strength. You’re intentionally adjusting the circumstances to start with a normally difficult prerequisite and complaining that it’s too overpowered.
Start with 8 strength and get a greatbow in a week and we can talk earlygame balance.

For a wooden spear.
You’re taking something unrelated and applying it to something with a solid rationale and saying it’s not okay because the two don’t match up. The only issue here is that melee weapons don’t scale proportionally with strength, and that’s not an issue with bows.