I have seen raw 2k captures of contemporary 35mm first-generation film that look pretty lame. Anyone who thinks it's as easy as finding film, sticking it in the scanner, pressing a button and hey, presto! you've got yourself a masterpiece, is sadly, hopelessly, irretrievably naive.
That said, I think good results could be had, with enough time and effort. And a little luck.