My favorite MF films are selected due to the differences in tone mostly, in the print (not the scan). Grain is a non-issue for me, it can be controlled to taste (i.e. if you develop yourself).
IMHO,
Ilford Delta 100 and 400 - like the way black is rendered, and the sharpness
Ilford HP5+ 400 - softer look than above, but a classic and slightly grainier look
Ilford FP4+ 125 - similar to HP5+, but sharper, and not as soft, I like the blacks on this too
Ilford 3200 - soft look, really big grains, good for achieving a certain look. Very useful in low light of course
Kodak Tri-X 400 - a classic look, and sometimes even a subtle midtone sepia to it. Not as sharp as Delta, with good highlights. As for Tri-X grain, I have yet to encounter it as significant, and I only print from 8S upwards for MF. I even had some developed by Rice Ball, grain is really a non-issue, the proprietor immediately knew it was MF.
Fuji Astia Neopan 100 - similar to a Tri-X, but sharper
Fuji Velvia 50, Velvia 100F, Provia 100, Provia 400 - color slides, I like the saturated look.
Fuji NPH 400 - for people, popular as a wedding film
I cannot really use my Hassy in low light without a tripod, lowest I can go is 1/30. That's where the RF comes in. Szekiat's recommendation of the tiny compact tabletop tripod is good, you can fit it into your bag. Without a tripod, it can still look fine to me, but only if the picture is small, like 4R or 5R - not my thing ...
.