Hey, hsandler, photoshop curves opens up a lot of possibilities for tweaking films to look like this or that, but they still only do so much, and it's often obvious in the end print what's going on.
For instance, Tri-x in HC-110 is going to scan a lot different and give you a much different tonal palette than tmax 100 in xtol. You can spend time in photoshop tweaking to your heart's delight to make them look like something they're not natively, but at that point I'd offer that you might as well just capture digi and use a plug in, since the power and beauty of film is what it does intrinsically when used in specific ways.
W/ that, a few things I've found over the years, and ymmv: Negs that print well and are good to work w/ in the darkroom are also great to scan and work w/ in PS. On that topic, the scan and understanding the scanning software is hugely important, as it's so often the weak link in the hybrid process, and there's a huge amount of bad info regarding scanning on the web. With all the technical stuff, just as in the darkroom, some of the the most important things in this process are exposure and development. I know people always say that, but it's a journey, a rewarding journey, to find how you to personally expose and process for your look. This is why developing on your own is so great. Once you learn to build a nice negative, and get down a scanning method that builds a nice file from it, then you'll be on your way.
W/ that, I say to start getting your hands dirty in some film, scan some contact sheets of them, do some test runs, and see how they look. I think you'll find everything has a different palette. Start to find one you like, and then when you want to change something or make it better ask around on how to do that. There's a lot to be discovered and figured out for yourself in every step of the process to get a look. Imo this is why film work naturally has such unique signature creatively, since there are countless variables to play w/ and interpret for yourself.
FWIW, for your requirements I'd try TMY-ii (tmax 400) and try to process it in xtol. It's a great all round starting place. Speed, low reciprocity and push-ability for night stuff, but extremely low grain and still high acutance for your other tastes. And it's tonal palette is highly bendable through exposure and processing. Then further so in PS curves since it's a rather linear film as far as curves and makes for a nice starting point to go different ways. From there if you decide you want more grit you can try a more high acutance developer like rodinal, or if you want a more dramatic curve a developer like HC-110. Or if you want a finer grain still you can go to tmax 100. Etc etc. I'd start w/ a few basics though and start testing it out and tweaking. Most of the magic is going to be in your exposure and dev and then the interpretation of it in PS. Learning this will take you way beyond using c-41 process films.