does camshafts make a major difference in a 1993 camaro z28.

yes.

Don't go too crazy if you have to do emissions! You'll also need a tune to get the full benifits of the camshaft.