There is a vast difference between the things which are blocked because youre not using a turing complete programming language and things which are blocked because of the nature of that language though.
You'll probably run up against the former quite quickly. The latter possibly never.
Yeah but ‘Turing complete languages’ have their own limitations compared to no code, like being comparatively slow to develop in.
(In quotes because many/most no-code environments are Turing complete, but you still wouldn’t want to develop certain apps/logic in them)
This is all part of having a good level of intuition for what capabilities you are likely to need, and then picking appropriate technology.