"Do bigger cams require more RPM to move from a stop"

At a moderate acceleration rate----no, but it might take a little more throttle/clutch 'finesse'
At a higher acceleration rate----yes