It should depend on the dish and for who and for what occasion you are serving it. For pasta, I prefer cooking the shrimp without tails, the flavor is great and minus the mess after. For appetizers, definitely with tails on. However, it's true that cooking shrimp with tails on is considered to add more flavor to the overall dish.