Your best bet might be to just put a larger SD card in your phone. Failing that, get another phone with a good camera that you use just for taking photos, tethered through your existing phone's hotspot, so you have all the sharing features you mention.

I'm not super familiar with their ecosystems, but Insta360/GoPro/DJI probably have the most robust apps that will do something *CLOSE * to this. , but nothing that allows posting directly from the device as far as I know.

You'd still need to do a lot of the posting via your phone/computer on an app. BUT, I think your phone can just act as a bridge, with the files still stored on the camera (likely on a microsd).

Outside of static security cameras, no one's really putting SIM cards in cameras. You'll find a lot that will share contents via wifi/bluetooth, but that's still going to require your phone/computer to post.

With my Fujifilm, I can access my camera wirelessly and can even have it set to automatically send JPEGs to my phone, but nothing that will interface directly with social media. If anything, the size of the JPEGs and multiple redundancies would only compound your storage issues.

I didn't really think a high quality option exists for this. Most cameras would require you connect to your phone to transfer images for these kinds of functions. So, get a camera that can do that or a phone with a micro SD slot for more memory.

How about an ultracompact point and shoot camera like a Canon PowerShot/ixus HS or similar? You'll have the power of a proper camera with a much better lens and sensor than a smartphone would have, in a light, portable package.

Sounds like you are having a storage problem.

Dedicated cameras are better for quality pictures but they are very clunky to carry around. It doesn't solve your storage problem and it seems you are not looking to solve a picture quality problem.

The easiest solution tech-wise would be google photos. Set it up to automatically upload and delete the version on your phone. You can share uploaded pictures directly to social media or people. Youtube is also in Google's ecosystem so AFAIK you can prompt the AI in Google photos and create videos for Youtube. Note that if you take a lot of pictures you must pay to have expanded storage to support the above.

A similar self-host option would be immich.

Fujifilm just came out with a modern toy camera. Fujifilm Instax evo cinema or something like that. Not quite what you are looking for but may be worth a search. Depending on your smartphone an SD to usb C could take the photos of any camera and you could upload from the phone.