An “RV motor” or “cam” is just a small cam that is slightly larger than stock in duration and lift to help make more power.
How well will it perform in your car is a Compilation of various items you did not list. We would need a crystal ball (an actual working Chrystal ball that is) to know how it will do in your exact car.
You ask another question that contains what I guess is slang of which I have no idea what your talking about when you said, “but generally speaking wouldn't it pull the tires off of it just the way it is?.”
I don’t know what your asking here. “Pull the tires off of it?”
I don’t know what that means, or what your trying to say or ask.
(Edit, grammer, whoops!)