Cool, so go use something else then.

I was about to itemize your list of issues with either ways to fix it or approach it differently or point out inaccuracies, when i realized there is no point, you have made up your mind and you probably dont want answers but just want to have a rant. Thats fine though, gamedev is hard, especially on an engine built for everyone. which is why some people build their own rather than work out how to best approach things on the engine that they are using.

Too many times ive ran into issues or performance problems and thought "fuck Unity" only to discover a better way to solve said problem.

Prototype and test and profile everything before implementing anything into your project, and your life will be much easier.