The type of coffee is dependent on your own taste, although care should be taken to ensure the type of grind is suitable for the machine you will be using.
For pump espresso machine use a finer espresso coffee, and for filter machines use a coarser coffee blend suited for filter coffee machines. Most coffee is labelled to ensure you are able to select the correct type of coffee.
However the best coffee in the world will not taste to its fullest unless the delivery of the coffee is exceptional. Please see the related questions for more details on how to ensure the very best results from your choice of coffee.