First: Avoid the J-series Synology units. All J-series are meant to be cost-reduced, low power units, typically based on ARM processors. They will perform rather poorly, and be completely useless for any kind of video editing applications.

So when I get a NAS, what can I expect?

Lower performance than USB 3, but greater convenience because all your devices can access it simultaneously. You're going to want your computer and the NAS to be on the same Ethernet switch. Don't even think about doing anything serious over Wifi.

Would it be a good idea?

Yes and no. Yes, in that it could make a great backup target, and a handy way of storing non-video content for live use, like music libraries.

How is performance when connected to a network?

Depends on the NAS and the network. As I just finished writing up over here the rest of the traffic on the network can play a role in limiting performance, and the functional capacity of the NAS itself also plays a very key role in whether or not it can keep up with what you demand out of it.

Is it totally doable for live editing or is it best connected directly to my PC via USB 3?

Maybe. Depends on the footage you're working with. Unless you're getting a higher end model, know how to tinker with these things, and you're not working with like gonzo 4K footage it might work out, but USB 3 will deliver far superior performance, and it would be recommended you continue to work off something like this.

I'm less concerned about RAID... I'm really only doing this so I can have multiple drives using one power cable.

No, you're getting involved with RAID, so you need to be concerned about RAID. I have a write-up in the Wiki about RAID that gives you a sort of 10-foot perspective on the thing. The RAID tech you invest in will determine how you move forward in the coming years in terms of data protection and storage growth.

And if all you care about is the power cord then you're getting into this for the wrong reasons. IF that's all you care about you could get a DAS solution. You could go with just a simple dual disk dock, or a dumb 'ole JBOD enclosure, or get some kind of real RAID solution, either by buying a card and building an array inside your computer or in some kind of external enclosure, or by buying a device that handles RAID internally and exposes itself to the computer as a single dumb disk.

Currently looking into these two models:

Keep in mind that those are dual-disk models, which limits you to RAID0 and RAID1. This is quite limiting in terms of options, and in terms of volume. However upgrading capacity is cheap, since you only have two disks to replace (however this is only possible in RAID1, and impossible in RAID0 unless you've got enough external storage lying around).