I've done extensive testing with Starlink, and currently have multiple nodes across the world. I was fortunate enough to have early access to the technology and it's been exciting to watch evolve. It's been very reliable and when you consider the price/bandwidth ratio it's pretty hard to beat if you're unable or unwilling to get other types of service. Round trip delays are much less than what you would see with geo satellites.
With that said, you may want to read up on the differences between the RV and Residential service. Priority tends to go in this order: business, residential, and RV comes in last. They have also imposed a new policy to allow throttling on Residential services beyond specific data caps. Honestly, this isn't surprising as the service became more popular it was inevitable. The waitlist for Residential is an attempt to control density (service performance) in geographic locations. If there is a long waitlist for Residential in your area you may likely see slower speeds by having RV service. Also, you're paying more for RV for the same equipment and service but less guarantees, other than you can pause any time.
It used to be difficult to relocate a starlink system because they were tied to a specific node, now things have evolved and it's much easier to move the system geographically if needed - there is no advantage with the RV system here.
Lastly, if you need a public static IPV4 address you will want to look elsewhere - currently starlink utilizes CGNAT. I've heard they are finally offering public static IP's for Business but I have not confirmed this yet.