It depends on you.
Your field of view through a mask is rather narrow and an average light beam will fill that. So if you point you light where you are looking there is really no visual difference.
That said there is an added responsibility and task loading. It is easy to flashblind those around you by shining your light in their eyes. Gauges are harder to read, etc.
Generally you are more likely to see certain critters more often at night (octopus, crustaceans out and feeding).
But we have had numerous night dives busts. When vis is poor your light reflects back all the debris in the water, exaggerating the poor vis. We have also had dives with less life than the same dive midday. Like all dives, you just never know.
As to personality types, it seems some people really relax in the dark. Heart rate drops, air consumption goes down. The other type is obviously the opposite. And you just wont know till you try it.
Two final notes that may have an effect. If you are doing 3,4 or 5 dives a day staying up for the night dive will prove exhausting. You will be revitalized afterward but I have found I dont think as clear when I'm riding that much N2 and that tired. Needless to say, the next morning can be rough. For that reason I prefer early AM dives. Get to see the night stuff and then watch the sun come. Beautiful. Usually I am all alone (because no one wants to get up at 4am) and come out of the water fresh and ready for the day.
Then there is the biggest negative, for me. In the carib. there is a ton of plankton and creepy little bugs and worms that fill the water column at night. I am shooting pics so I have my primary and a focus light and multiple strobe bursts. These attract the critters. If I sit in the same place too long I am being pelted with critters. This may freak out some people. I am okay until one finds its way into my ear!!! This has happened twice now. Its so hard to focus when you have a "woosh wooosh woosh, flutter flutter" and the feeling of movement in your ears! I have also washed squirming worms out of my beard post dive. That is not so bad but it freaked my wife out. That said, that is 3 times I have been a "host" out of over 100 night dives so the odds are low, but still freaking creepy. One of these days I will get a head sock.
Anyway, you wont know till you try. Some people loves wrecks, some love caves, some love muck and some love reefs. Just don't do it for ego. It is supposed to be fun.
View attachment 430670