You said you'd like an offline flash update & macro programmer to not depend on cloud-based software, and that exists. Keychron hardware runs on open source firmware and is compatible with VIA as well as their proprietary Launcher. I just checked on my Q11, and the two softwares are basically the same.