I like Delta 3200 in 120 but not as much in 35mm. It looks too soft, seems to lack detail. I do have a couple of rolls of TMAX-3200 but as you say....I usually prefer to simply push HP5+
Most of my very low light B&W photography, under normal circumstances, is gigs in small to medium sized venues....most often from the front row or standing right in front of the stage. Nothing else quite captures the atmosphere of a small, intimate music venue. And the musicians I photographed in 2019 seemed to agree.
My first experiences with Fuji Super-G 1600 were at the LA2 in London mid 90s photographing a rock band who had a spectacular light show. I was right at the front, with the venue slightly oversold so there was jostling but no real crushing. It was magical to be able to take photos without a flash and actually capture the light show as it looked. The later Superia 1600 was indeed superior, much less grain. I had the honour of photographing that band over a 20 year period. They're looking at coming out of hiatus next year and have already requested my presence along with my cameras. It's nice to be an amateur and get noticed when there are professionals there.
I used to use Delta 3200 for taking night shots of streets, beaches, churches which had been lit from the outside. When film was "cheap" I would often have one roll with me when going on holiday, and it works really well for that purpose.