I think there's a saying along the lines that there's no stupid questions, just stupid answers....
As far as the questions you have, as well as the examples you refer to, -from my own experience, the most important part would be to recall what the word photography means!
Photo means light and graphy means drawing, -drawing with light...
Just keep in mind, the perfect photography is jet to be shot! Some have come rather close, as we all know.
From my own experience, the most important part is your own imagination! All the fancy equipment, all the nice gadgets and all the fine words are useless, if your imagination fails!
Keep in mind, the camera, the lenses and whatever, are just tools! Vital for the job, -ok, fair enough. But the best camera in world and the best lenses, etc. are just tools and instruments for using your own imagination....!
When this is said, I'd like to point out; a good, sturdy tripod is a MUST for photography in low light/night settings. In my days, I used a simple Slik Master Standard, which did the job. But I modified this tripod ever so slightly, bu mounting a kind of a "hook" to the bottom end of the column. On this hook, I attached a weight of 10 -15 kilos, -and the tripod was rock solid!
I goot quite a few excellent night shots, in the streets of Utrecht, Holland, among else.
As far as the "Soft Focus" photo is concerned, -well, there's allways the old trick of putting some Vaseline, on the edges of an UV filter, or skylight filter....
But today, you can probably make something similar one the computer, I guess...?
I'd just like to add; in view of all the digital hocus pokus that's available today; all the digital wizardry in the world can't make a bad photo good, but you can destroy a good photo....!