We study the finite temperature phases and collective excitations of hardcore as well as softcore bosons on a square lattice with nearest and next nearest neighbor interactions, focusing on the formation of various types of supersolid (SS) phases and their stability under thermal fluctuations. The interplay between the on-site, nearest, and next nearest neighbor interactions leads to various density ordering and structural transitions, which we have plotted out. Thermodynamic properties and phase diagrams are obtained by cluster mean field theory at finite temperatures, which includes quantum effects systematically, and they are compared with the single-site mean field (MF) results. We investigate the melting process of the SS phase to normal fluid (NF), which can occur in at least two steps due to the presence of two competing orders in the SS. A tetra-critical point exists at finite temperature and exhibits intriguing behavior, which is analyzed for different regimes of interactions. The phase diagrams reveal the different pathways of the thermal transition of SSs to the NF phase, for different interaction regimes, which can be accessible by thermal quench protocols used in recent experiments. We show how the phases and the transitions between them can be identified from the characteristic features of the excitation spectrum. We analyze the appearance of a low-energy gapped mode apart from the gapless sound mode in the SS phase, which is analogous to the gapped mode recently studied for dipolar SS phases. Finally, we discuss the relevance of the results of the present work in the context of ongoing experiments on ultracold atomic gases and newly observed SS phases.