Silicon carbide-based thermal spray powder, method of preparation and use