Yes, solid is basically for max HP and will need periodic adjustment, hyd. roller will not go in your motor without additional work to make the lifters stay in and work and the cost of the roller camshaft and lifters will be ~$1,000 or 2X + what a hyd. flat tappet will cost. Hyd. flat tappet is what came in your 289 originally and will be the easiest change out of the 3. Go to compcams website
click learn more> then find my cam> under hyd flat tappet and it will suggest cams based on your answers.
You didn't say what year your 289 is so I'm just guessing '65-'67, you will notice that the lower the cam number the milder the lope/cam i.e. a 270H is lopier/more agressive than a 260H, etc., they have more than what shows up I notice though since it doesn't suggest any extreme energy (which is what I have) so I would start at the full list here:
The biggest caveat with a hyd. flat tappet is break in period (20 min.) and that you add a ZDDP additive at every oil change or use an oil with higher levels of ZDDP (~1200ppm) for oil changes. Comp cams sells an additive or you can pick it up at a local parts store ~ an extra $10 every oil change, not bad.
You should ask this question (or have it moved) in the classic section or the general discussion section, ask MCA is more for membership questions vs. engine questions.