I agree about Nemesis, back row Nemesis at night was one of the most intense ride experiences of my life.
Some more notable coasters that were pretty insane at night are: Dragon Khan, Port Aventura.
It was unbelievably intense and you really had no clue where you was about on the ride's layout.
Another at Port Aventura was Furius Back. To be honest, it's extremely intense in the day time anyway, but when you ride in the night when it literally has NO lighting at all on 90% of it's layout, it just becomes in another league. It was a little too intense in sections.
I also quite like Oblivion on a night time as well, I think the limited lighting on it also enhances the ride itself.