How does a solid roller cam act vs solid flat tappet

it's said big ports are good for the short rod & and small for longer rods. That part makes sense.
But I'm no expert.
I never heard that. I just build with the stock rod ratio and tune to the engines needs. I’m on the street mostly with A rare trip to the track.