Efficient matrix product state methods for extracting spectral information on rings and cylinders