Thin-film piezoelectrics are widely investigated for actuators and energy harvesters, but there are few alternatives to toxic lead zirconate titanate. Biocompatible Ca- and Zr-modified BaTiO3 (BCZT) is one of the most promising lead-free alternatives due to its high piezoelectric response. However, the dielectric/piezoelectric properties and structural integrity of BCZT films, which are crucial for their applications, are strongly influenced by the substrate upon which the film is grown and the related processing methods. Here, the in-plane stress, microstructure, dielectric, and piezoelectric properties of 100–500 nm thick high-temperature RF-sputtered BCZT films on industrially relevant Si-based substrates were investigated. Obtaining polycrystalline piezoelectric films required deposition temperatures ≥ 700 °C, but this induced tensile stresses of over 1500 MPa, which caused cracking in all films thicker than 200 nm. This degraded the dielectric, piezoelectric, and ferroelectric properties of films with larger electrode areas for applications. Films on SrTiO3, on the other hand, had a compressive residual stress, with fewer defects and no cracks. The grain size and surface roughness increased with increasing deposition temperature. These findings highlight the challenges in processing BCZT films and their crucial role in advancing lead-free piezoelectric technologies for actual device applications.