I'd be more than open to some decent local shore dives, but most of the people I know seem to go at least some distance.
I seem to be visiting Venice at least a few weekends a month for shallow water dives, though visibility can be sketchy. Best I've had there was 12-15 ft, but the worst was mere inches.
Venice is only 90 mins or so south, and there is a chance for finding Megalodon or fossilized sharks teeth if that's an interest. (there's a forum group set up for Venice fossil divers if that interests you.)
I'll keep watching this thread for places closer to home too....