Flat tappet:
Good for high rmp but noisy, if it's too agressive, it might eat a lobe.
Hydraulic flat tappet:
Pretty good rpm, quiet, if it's too agressive, it might eat a lobe.
Solid roller:
Extreemly good for high rpm, may need very stiff valve springs, the needle bearings in the rollers...