The soild roller is better suited for high RPM use, say 6500 + RPM. One of the downsides is the valves need to be adjusted fairly often. Anderson Ford makes their High-Rev hydraulic rollers, and they seem to offer the best of both worlds.
Not only will the adjustment have to be done with a solid roller, but they are a little noisier too, will sound like constant valve clatter, although perfectly normal.
Unless you are racing only, stick with a hydraulic roller cam. Do you want to pull your upper intake each time you have to adjust the valves?