I'm not sure how great the video quality will be, though I'm planning to get this new Note3 that shoots 4K. Can 4K footage from this phone be brought into CS6, without converting it to some other format?
It shoots 4k at 30fps
That is what the scuttlebutt says. It can do 1080p at 60fps and 720p at 120fps.
My guess is that the video will use the same codec that they use for the HD, which works fine on my system. I have the Galaxy SII. The Android video is pretty easy on the computer.
However, as cc_merchant says, try it for yourself and you will know for sure. The only 4K link I could find overwhelmed the server it was on, so I couldn't download it.
They may reduce the bitrate to get the files sizes down to a reasonable limit. That might destroy the ablility to properly edit the video. But you will not know until you try.
As for image stabilization, I suggest that you get a tripod for it if you expect good video. I have one for my phone, but I had to modify it to get it to fit. The Note is even bigger, so a bigger modification might be necessary.