Even if you do this it'll often continue with the design that got "baked in". For example, say that you said you wanted private user views, and there was already a way to have views and a way to have permissions, but opus for whatever reason went and made a user-private-views table (side note: I mean brand new table, not a view!) on top because it's not a human being with opinions and it just needles on your prompt without taking a holistic view.
Then, your LLM code reviews will never call this out. You have to look at the code yourself and correct it. If you don't, this type of monkey patch engineering will proliferate and make your codebase so awful that your successor will become a homicidial maniac.
That said, you're correct that even the code reviews often need to be triple checked before they are worth anything.