We don't "need" open questions.
This place is not a forum or a chat room which are suited to long discussion and exchanges. On the exchange sites, people write answers and, hopefully, one is accepted.
If you ask how to do configuration management with Puppet, we would need an answer that is at least as long as the getting started: https://puppet.com/presentations/getting-started-puppet (17 pages long)
I hope you understand why that is not a good question. Here is not the place to introduce a whole subject, or to teach about how to do something, or even discuss what is best.
Refer to "How to ask" for guidelines https://devops.stackexchange.com/help/asking These guidelines have been written and improved over time and with experience on many over stackexchange site.
Also keep in mind that the very fact that answers are voted is a case against "open questions". If someone ask how to do secret management and we leave that question open, what will happen is that 1) we'll get 50 different and very lengthy answers. The reader will have to read through them, figure out why someone suggested something and why someone suggested something else. And then 2) in in a year or two, the secret management field will have changed and these answers will probably be invalid (not obsolete, they'll be downright wrong in regards to the new standards). The preferred way to do secret management will have changed and you have to hope that someone posted an updated answer and hope that it gets up-voted enough to have some visibility.
Specific questions are better, if you ask how to manage rotation key secret in Consul with Spring Boot it protects you to some extent from those change over time in tools and procedures. If someone is still using Spring Boot with Consul in 4 years, well.. they will have a very specific answer to their problem. That's a good thing. To the rest of the community which will have moved on to "NextGenSecretMgmtTool", this question about Consul will just appear obsolete and won't tell them how to secret management and won't suggest to use Consul.
PS: I have nothing against Consul, all I'm trying to illustrate is that tools and techniques change over time and the answers written usually won't.