I've done P90X3, Les Mills Combat, and the first workout of P90. My favorite of the three was Les Mills Combat. (Beachbody doesn't distribute it anymore), but I really liked P90x3. It provided a balanced workout with plenty of variety. Tony Horton is a little over-the-top, but you kind of get used to him. The thing about the original P90x was that the workouts were an hour long, but a significant portion of that time was Tony Horton talking.
The key to getting the most out of P90x is consistency. If you follow the program, you are going to see positive results. It all depends on how much you put into it.
I wish you the best in your fitness journey. When you're sore, remember that feeling...it's called "Change!"