I have to recommend the pastries at Sette Pane/Bruno Bakery on Lorimer Street in downtown Brooklyn. They have the most delectable fruit tarts as well, for half what you'd pay in Manhattan. A great host/ess gift. And it seems to be a family affair, with the sweet little nonna behind the counter the last time I went!
Any other sfogliatelle recs would be appreciated.