The number one hybrid in my area is Chambourcin, just about every commercial vineyard is growing it. As for other hybrid recommendations, others on the board are far more knowledgeable than I, but I've heard good things about Marquette, Frontenac, Baco Noir, Chancellor, etc.
Pinot Noir has a reputation for being very difficult to grow, if you're dead set on trying a Vinifera I'd say Cabernet Franc would be the best bet. It's similar to Cab Sauvignon but ripens earlier and is a little more cold hardy. Honestly though, I'd stick with hybrids, unless you just want to try a few vinifera to see if they'll survive/ripen