Currently, there are 4 types of cams being used.
1. Solid flat tappet. This is the cheapest cam to buy. Very basic, no frills or fancy stuff. Tappets (same as lifters, just a different word to describe them) are "solid", with no provision for an internal plunger or oil. Valve lash (there must be some play in the system, otherwise the valve could be held off the seat all the time) is accomplished by manually adjusting at the rocker arm or with adjustable pushrods from time to time, usually figure on adjusting the valves every other oil change for a street driver. Lots of roundy-round racers use this type cam. Will allow maximum revs compared to hydraulic cams. Bottom of lifter is cut on a long radius, can't remember, maybe 50 inches. Tie down a 50" long string to a nail. Tie a pencil onto the other end of the string and describe a short line (roughly 7/8ths of an inch long) on a piece of paper. That very shallow radius is what the bottom of a flat tappet should look like. I'm trying to get you to understand that the bottom of a flat tappet is not flat, but crowned. It rides on a cam lobe that has been cut on a downslope from one end of the lobe to the other, so the edge of the cam lobe rides on the crown of the lifter and spins it in the lifter bore. There is only a very tiny contact point between the lifter and the cam lobe. If lifters are too tight or too loose in their bores, they will not spin properly and the cam lobe rubs on the same spot again and again. This will destroy the bottom of the lifter, which then destroys the cam lobe and things go south in a hurry. Flat tappet cams can also be destroyed quickly with excessively stong valve springs. That small pencil point of contact at the lifter crown/cam lobe can't take but just so much pressure without galling the steel by wiping off the lube between the parts. Requires a complex break-in procedure to prevent premature failure. Also requires that extreme pressure lubricants be added to the engine oil with each oil change or use an oil that still has these EP lubricants in it (dedicated racing oils such a Brad Penn).
2. Solid roller tappet. More money. More complexity. Prettier parts. Roller tappet cam lobes are ground straight across, with no slope to the lobe as you look at the cam along its length. The rollers on the lifter are also ground straight across, flat, so that the roller rolls around the cam lobe making full contact between the lifter roller and the cam lobe. Because this is still a mechanical tappet cam with no automatic adjustment at the lifter, the owner must do periodic lash adjustments just like with a solid flat tappet cam. This is the cam of choice for anyone looking for max performance, regardless of price and freedom from worry about one of the lifters going south and taking a lobe out with it. No break-in process required. No special EP lubricants required.
3. Hydraulic flat tappet. Same basic design as solid flat tappet, except that the lifter is designed to adjust the valve lash automatically after the initial valve lash adjustment at the time of engine build. Will not rev as high as solid flat tappet due to the lifters "pumping up" and holding the valves off their seats at the upper rpm operating limit. Best used with reasonable valve spring pressures, stock rocker arm ratios, closely observing the break-in process and inclusion of EP lubricants in the engine oil in a daily-driver type motor where the owner does not wish to adjust the valves periodically. There is still a plethora of offshore (Chinese) lifters floating around in the marketplace. The price of these parts makes them very attractive to amateur engine builders who are unaware of the quality of these parts. If you are going to use hydraulic flat tappet lifters (which I do not recommend), then by all means try to find the best lifters money will buy. Get the whole mess as a cam/lifters/springs/retainers/locks/shims package from a well known cam grinder.
4. Hydraulic roller tappet. Same basic design as solid roller tappet, except that the lifter is designed to adjust the valve lash automatically after the initial valve lash adjustment at the time of engine build. This is the heaviest lifter among the 4 types outlined here, therefore it will have a lower rpm limiting range than a hydraulic flat tappet. The lifter actually begins to separate from the cam lobe at design limit engine speeds, requiring either reduced engine speeds or the inclusion of an additional "rev kit" set of springs in the lifter valley to assist the heavy lifter in staying in contact with the cam lobe. Generally speaking, this rev limit without the additional rev kit will be around 6200 rpm's. If the owner can absorb the initial cost of this design, it will be the most maintenance-free of the 4 types outlined here. No break-in procedure. No EP lubricants required. No worry about valve spring pressures roaching the lifter. This makes a great daily driver or street/strip cam.
To answer your other question, roller cams can have a much more agressive lobe design because there is no edge of a lifter trying to dig into the cam lobe like there is on a flat tappet type cam. You can WHAM, yank the valve open, leave it open longer and WHAM, slam it closed. The lobes on a roller cam look more rectangular than egg shaped like on a flat tappet cam.