You can't generalize - it depends on the specific lens and intended use.
One reason why a newer lens "optimized for digital" might be problematic with film is that lens designers are increasingly making tradeoffs in which certain optical defects - notably linear distortion and vignetting - are less stringently corrected in the design on the assumption that they will be corrected or compensated for in post-processing of the digital capture. This is especially true of lenses made in mounts for mirrorless digital cameras, which are irrelevant to film photography because there is no practical way to adapt them to film cameras. But it can affect lenses in legacy mounts as well.
That said, some of the very best digital-generation lenses in legacy mounts are well-corrected across the board and ought to be spectacular for film photography, especially for those who want to take full advantage by using slow films and meticulous technique. For example, having had the opportunity to test it on a high-resolution digital camera a while back, I'd be really interested to see what the Zeiss Milvus 35/1.4 can do with T-Max 100 or Acros. Or one of the Zeiss Otus lenses, which I haven't tried. Of course, keeping the OP's concerns in mind, these are very large, heavy and expensive lenses, and some prospective users, if they can tolerate that much weight, size and cost, might be better off going to medium or even large format instead. On the other hand, I have shot my Canon EF 40/2.8 pancake lens on film as well as digital, and it's every bit as much a delight on film as it is on digital. It's tiny, featherweight, and a steal at the price.