Many ways to go. For the vast majority of YouTube, 720P is overkill.
For transfer, also many. Tried and true USB to computer. I just yank the memory card out and stick it into my computer, or a "card" reader which is then USB. Many new cameras have bluetooth or other wireless transfer capabilites.
This video (the battery died LOL) was uploaded with a camera I paid 80 for used, a little Canon SX500 IS. It is NOT primarily a video camera, but a still camera with video capabilities
I don't know whether you are looking for a "GoPro" --ish or "general purpose" camera which would be more versatile. If that, you might put "Canon Refurbished" into search and look around there. I've bought several cameras from them that way, and they ALL looked and functioned "as new" with a reduced price (and reduced warranty.)