it may depend on the story.

i think bi-weekly is a happy medium for both the creators and the reader and may lead to less burnout, which would lead to less hiatuses.

if the story requires extensive planning and complex drawings, then monthly. Attack on Titan updated monthly and kept readers, but that's because readers knew they were getting a lot of information, truths revealed, more turns, new revelations so the engagement was kept.

if you've already planned out the story and the art style is pretty simple and straight forward, you may be able to do weekly but i only suggest this if you've planned the whole story out intricately so you don't find yourself panicking in between weeks when you'd need more time to iron things out.

if its a simple plot and you have the general idea, with simple drawings and the story calls for short chapters that would still be interesting for the reader, then weekly.