I'm going to avoid discussing consciousness by saying that it might be a property of a system like information entropy. Intelligence and understanding are also not well understood. So let's go with a practical definition.

We want systems that can do almost any job. This can include using arms, legs, generating text, audio, images, or video in a useful way. Most of these tasks seem doable, but if you have to take into account all the variables, I don't think you can write down a conclusive answer.

Is it achievable? It depends on the architecture, algorithms, hardware, financial resources, availability of experts and maybe seven other factors.

Can we find a good enough architecture? If we can understand the human brain better, yes Otherwise we can only guess. The brain is self organising, decentralised, and asynchronous. This differs from many Deep Learning systems.

We could hit a wall. Even with all the data in the world, the neural networks could become too complex to train and use. Data quality is naturally also a problem. But quantum computers would surely help. However, it's too early to commit to that option. In the end I think we would have a free market of narrow AIs for the foreseeable future But of course there could be unknown unknowns, so the answer for now is Maybe.