There are still significant limitations, no amount of prompting will get current models to approach abstraction and architecture the way a person does. But I'm finding that these Gemini models are finally able to replace searches and stackoverflow for a lot of my day-to-day programming.
Either you have no idea how terrible real world commercial software (architecture) is or you're vastly underestimating newer LLMs or both.