AI is definitely harder on framerates, as your PC has to calculate everything going on for them, as well as the detailed calculations for yourself. Whereas in MP, you are just receiving the precalculated locations for other vehicles, and you aren't actually performing the physics calculations for those vehicles.
AFAIK human versus AI is the most intensive setup. AI control of human car, versus AI, or human versus MP human, less so.