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.