You definitely get different textures from different cheese. The sharp cheddar gives it a grainier texture and the mild is smoother, White cheeses like Provolone will add smoky flavor, Parmesan a little "bite". Some folks also throw in some velveeta to make it smoother.
It is all just what you like I suppose.
