Will low code software create a maintenance nightmare?

To a vary degree yes.

I prefer open source low code platforms like Budibase (https://github.com/Budibase/budibase) because they improve maintenance and reduce technical debt by providing access to the code base.

I am always a little nervous when using Microsoft dev tools - i feel like they attempt to trap you in their walled ecosystem.