Back in the 80s I ran some roller cams on the street, and despite being careful to rev the engine in traffic to keep the lifters splash-oiled, the lifters still eventually went bad. The needle bearings would fail, and then take out a cam lobe or worse. I probably got 1000-1500 street miles out of a set of lifters.
However, nowadays there are better options available. The pressure oiling to the needle bearings that is available with many roller lifters goes a long way to making them live on the street. I've gone as long as 10,000 miles on a set of Crower HIPPO mechanical roller lifters on a Comp 308R roller cam. And of course with the bushed lifters that are now becoming available (no needle bearings, just bushings), I'd guess things are even better.
One thing about mechanical roller lifters is the lash required automatically means that once every two engine revolutions, the lash is taken up between the roller wheel and the cam lobe. Crashing the wheel into the cam lobe has got to eat into the lifetime of the lifters. Hydraulic roller lifters don't have this problem, of course; with a hydraulic roller the roller wheel is always in contact with the cam lobe (unless you float the valvetrain), so there is no hard contact. As a result hydraulic roller lifters should last a lot longer.
Valve spring pressure will come into play as well. The more spring pressure required for the cam, the harder it will be on the bearings in the roller lifter, and probably the shorter time it will last. On the 308R mechanical roller that I mentioned earlier, if I recall correctly my spring pressures were 200 on the seat and 560 over the nose. The 504" FE currently on my dyno uses spring pressures of 290 on the seat and 750 over the nose. No way those lifters are going to last as long as the ones with the lower spring pressure.
Whether or not you use a mechanical roller on the street should be based on the number of miles you want to drive, and how radical the cam lobe and spring pressures are. A lot of us don't put much more than 1000 miles per year on our FE cars; with a reasonable cam and spring pressure, I wouldn't be afraid to go 10 years before checking the lifters in a situation like that. On the other hand, if you plan to drive 2500 miles per year and you have open spring pressures exceeding 700 pounds, I think I'd be installing a new set of lifters each year, just to be safe. As Joe mentioned, when the needle bearing versions go bad, they can cause a lot of damage...