I frame usually contains its own players hence, it's not recommended to use as background video. Plus, the background video is implemented as HTML5. And adding the video URL doesn't mean you have to host it locally on your site. You can upload it somewhere and use its URL. And I think vimeo offers video URL, I think.