Luminance noise can be surprisingly pleasant on a full-frame sensor, although I still go out of my way to avoid it where possible - not hard lately as my full-frame body has been dedicated to macro, and macro wildlife photography already requires the kind of exuberant flash setup that makes noise very easy to avoid.
(For those interested: Nikon D850, Micro 105mm f/2.8 VR II, three SB-R200 heads on a forward ring with a wireless controller on the shoe. I usually shoot at 1/250. f/11, and "L1.0" ie ISO 50 equiv, with the flash set to make up exposure. It's a fairly complex rig, but very simple to use, to the point where I don't worry much about whether I'll get keepers when shooting wild wasps unless I'm right up at 1:1 and a 6" working distance.)
Right there with you on film versus digital. I get the nostalgia and I do still have Grandpa's Nikkormat FTn that I learned on as a kid, but I did shoot film as a kid and I'm not sorry to have moved to digital, not least because I'm certain I could not do the kind of work I do - chasing wild wasps around or finding places where they congregate, and shooting them as they go about their occasions undisturbed by me - without digital.
So far as I can tell, there aren't that many photographers out there who do that kind of work at all, and I refuse for both ethical and competitive reasons to join the ranks of those insect macro shooters who capture and kill their subjects - they certainly do produce beautiful images, but I don't respect the means by which they do so. Sure, I can't stack focus to get shots sharp all the way through, but so what? When you look at my work, you can do so in the knowledge that the trajectory of life out of which you're seeing that 4ms slice was in no way deflected by my efforts in documenting part of it - and I also have the satisfaction of knowing the same, as well as that I'm doing a kind of work that is in a lot of ways harder than theirs. Sure, you can screw up a stack and have to reshoot, but when your subject will never move again because you've killed it, all that costs you is time. Meanwhile, my dilettante ass is over here trying to capture moments that have never existed before and never will again, and sure, I don't always get them, but I do get them. [1]
I think that's worth more than all the perfect focus stacking in the world ever will be, and on film I can't imagine being able to work that way at all, because those wasps aren't waiting around for me and I wouldn't want them to. (Well, aside from the one time they got so used to seeing me by a caterpillar nest that they started using me as a waypoint on their route to it! That was oddly sweet to realize, but it was their choice, not mine, and I suppose that's the point.)
[1] https://aaron-m.com/wp-content/uploads/2021/01/DSC1220.jpg