I disagree with many here. Even on a moonlit night, or over a well let area, there are moments where you’re just not going to have a good horizon. The moment after takeoff is a great example: you’re pitched up well above the horizon, you’ve just left the airport environment so your night vision may have been spoiled by runway lights, lights from other aircraft, vehicles, etc. Not a good time for spatial disorientation.
I’m of the opinion that if I won’t fly through clouds with my instruments, I’m not going to fly at night with them either.