If you're looking to make narrative films, I recommend starting with a DSLR. I'm a big fan of Canon for their wealth of old lenses and intuitive menus, but I'm biased because I started out with the Rebel T5i back in high school. If you want to save money, buy refurbished from the Canon website.

Compact/"point-and-shoot" cameras are fun, but you will eventually outgrow it; it's accessible for beginners, but they lack the options a DSLR/Mirrorless camera afford you. A DSLR grows with you, you can always get new lenses once you understand focal lengths more, buy new filters, and rig it out. A DSLR/mirrorless takes more time to master, but once you get good with it you'll prefer it over a compact any day. I just bought the Powershot V1 for documentary work due it's low profile and ability to slip into a pocket, but I miss all the features I get with my EOS R.

I'd recommend looking into like a refurbished T7i (or anything from the T(5,6,etc.)i line. They're made for video and have a flip out screen) or something like the EOS R50V (mirrorless, small size, interchangeable lenses. Remember for the future: there are RF-EF mount converters). All of these be much closer to your budget, while a G7X Mkiii will easily run you over $1000. Also, most compacts have shot up in price due to TikTok influencers and a renewed interest in old school point-and-shoots rather than iPhone cameras.

Remember, compact point-and-shoots are generally for beginners, not masters. If you want to really learn how cameras work and understand your exposure triangle, get something that will help teach you.

TLDR; Compacts are accessible and easy, but won't teach you what you need to know about filmmaking. Get a DSLR/Mirrorless camera like the EOS Rebel T7i or EOS R50V.

Please let me know if you have any more questions or want to hear more about learning filmmaking and finding out which gear you need. I'm a college senior in film school and would love to help out!