I've come across different questions at different networks that get closed, the reopened, then closed again...
It's often about questions that represent an edge-case for what's on/off-topic on the corresponding site, or "maybe-opinion-based" questions.
What often happens is that a few people don't think the question is fine and vote to close it while people who think it is can do nothing. Then, when enough "close" votes are reached, the opposite happens (reopen votes until the threshold is met)
I don't know if you think this is fine but for me it's chaotic. A question is either on topic or not, but it can't be on-topic on Tuesday and off-topic by next Friday only to be on-topic again in the weekend. I can think of a few alternatives.
- Closing a question becomes definitive - This appears to me as way too harsh and losing value for the sites (maybe a good edit could save the day).
- Creating a "do-not-close" vote - Questions wouldn't get closed until the "close vs do-not-close count" reaches a certain point (5 more votes for closing, or maybe at least 3 and 66% of total, or any other criterion). Then, questions shall only be reopened by a moderator after an approppriate edit is made.
- Put the "closers" on trial (i.e. make us reputation-responsible for what we decide to flag and close). This means that sound close-requests should be awarded reputation while unsound ones should imply a loss in reputation
NOTE: This is my recent experience:
I present you a closed question with 3 reopen votes while this post is being made. This question will probably be closed and reopened as well. Meanwhile, this question has gone through the entire process. I was writing an answer when it suddenly got closed for a few days. Now it's reopened but it's really painful to take the time to rewrite the entire thing
EDIT: This question was closed as duplicate, but the linked question is more than 10 years old. A large majority there agreed with the second proposal but nothing has been done since! I would like to understand the reasons why. By the way, if this question gets reopened, it would be the most-meta question ever!