It depends on the type of show.
If you have something that is based on tension, intrigue, a mystery, or a general spectacle which leaves you on the edge of your seat, or has an active community which is part of the fun of following, then week to week all the way. So things like Breaking Bad, Better Call Saul, The Boys, the star wars and marvel series, Game of Thrones, etc.
If you have something which is a bit more about atmosphere, tone, a matter of fact story, or of course a story which is real life (because not much point having a weekly thing if you know what will happen just by searching for it), then all at once I would say. So things like Mindhunter, or Narcos, or We own this City, or The Crown, or a show I have just watched called The Newsreader.
So yeah it depends.
I think the worst case I have ever seen is for an Anime I like, Jojo's Bizarre Adventure part 6. Netflix got the exclusive rights in the west which used to be Crunchyroll and released weekly. Being an anime which is about weird and wakey superpowers fights with lots of twists and turns, and a large active fandom, weekly showings suited it to a T.
Netflix instead did a really weird thing where they released like a 3rd of the season early all in one go, and won't be releasing the rest until another year or so, again all I one go. This killed the hype for the series, killed the fandom talking about it weekly as exciting and stupid shit happened, and blew all the tensions right away (also didn't help that Netflix had it going at a much quicker pace than other seasons).