Any further education is of benefit for a pilot, regardless of using it later on, or not.
Yes, I really enjoy flying VFR at night, but you have to keep in mind that emergencies are even less funny. During my NVFR training they had the saying that at day you survive 90 percent of engine outs, but only 10 percent at night. NVFR training does also do good for navigational skills (similar to CVFR or light IFR) and radio OPS on RADAR freqs, so yes, if you have a chance to do, do.
For practical use, think of your usual flying profile and if you ever run into trouble being late, compare the risk of get-there-itis to simply stay calm and file NVFR. If you potentially want to go IR, NVFR is a real nice step and in my view almost a necessary one.