Placement matters more than production quality. A short video on a service page, positioned where somebody is deciding whether you can handle their situation, earns its place. The same video on a page called videos, or in a carousel on the home page, is decoration. The test is whether it answers a question the visitor is asking at that exact point on that exact page, and if you cannot name the question, the video belongs somewhere else or nowhere.
Never autoplay with sound, and be cautious about autoplaying at all. It is the single most reliable way to make somebody leave a page, particularly on a phone where they may be somewhere they cannot make noise. It also consumes their data before they have chosen to spend it. A still frame with a visible play button, chosen deliberately rather than accepted as whatever frame the platform picked, converts better and irritates nobody.
Host it somewhere built for video rather than uploading files directly to your own site. Video is heavy, and serving it from your own hosting will slow every page it appears on, which costs you more in abandonment than the video gains. Embedding from a video platform means it is delivered efficiently, adapts to the viewer connection, and does not compete with the rest of your page for bandwidth.
Add captions to everything, without exception. A large share of video on the web is watched with sound off, particularly on phones and particularly in public. A video without captions is a video that a substantial proportion of your audience will scroll past rather than unmute. Captions also make the content readable by search engines and by anybody with a hearing impairment, which turns a courtesy into two additional practical benefits for the same effort.