As a novel hybrid quantum system, cavity optomechanical system shows super strong coupling strength, extremely low noise level and considerable coherent time under superconducting condition. In this paper, we briefly introduce basic principles of cavity optomechanics and cavity optomechanical systems. Meanwhile, we also classify the widely studied cavity optomechanical systems as five categories in their materials and structures. Significant parameters of these optomechanical systems, such as quality factor, mass and vibrating frequency of mechanical oscillator, are listed in detail. Technical merits and defects of these optomechanical systems are summarized. Furthermore, we introduce the research progress of non-classical microwave quantum states preparation by utilizing generalized cavity optomechanical systems, and we also analyze the performance advancements and remaining problems of this preparation method. In the end, we summarize the application cases at present and look forward to the potential application scenarios in the future. Our summary may be helpful for researchers who are focusing on quantum applications in sensing, radar, navigation, and communication in microwave domain.