Silicon carbide based plasma sprayed coatings