NY, isn't that part of the rust belt?
Unless you found a garage queen, I'd avoid it.
If I were to find one, after going thru all hoses/lines/seals/gaskets/rubber, I'd probably convert to FI, keep the catalytics(or newer high flows), and lose the egr and various emissions mess.
I've had no issues with the c6. Back in the day, drop/rebuild/reinstall a couple before lunch. Too bad no one adjusted or serviced transmissions back then since they'd all last much longer. They had 'lifetime' transmission fluids and filters too!
And, you get to run 15w40, 20w50, or some really thin 5w40 and no one will bat an eye.
There are no good years. If you're not a competent mechanic, good luck finding one. Old cars, boats, RVs, younger wives... all are expensive hobbies.