Kntrim, welcome to the forum. I'm 39 yrs old living in Broward County, Florida, but I lived the first 35 years of my life in Queens, NY (Forest Hills, Rego Park, Bayside). I know what you're going through trying to get a gun permit. I'm actually surprised you're getting one. Most folks i know were told their information was lost after about 7 months and that they'd have to re-apply. I knew one guy who had anice nickel plated S&W .357. We shot it once or twice. Unfortunately, he was my girlfriend's father, so there was always a bit of caution involved when the gun was discussed.
Anyway, I like semi-autos. I like the Beretta 92FS and the sig P226 or the new P250. If you're not going to carry it (and unless you own a jewelry store, good luck getting a carry permit in NYC) then you should get a fun gun. You don't have to worry about being in a "shooting" situation and fumbling with the slide or clearing a misfire when your life is on the line.
For home defense, YES, get a revolver. Some of the suggestions in this thread have been excellent. And I think .38 spl Jacketed Hollow Points are fine for home defense. You DO need to be concerned with your backstop and whether the walls will stop your bullet.
And make sure the castle doctrine is the law for NY or you won't be able to shoot an intruder in your home unless to make every attempt to retreat.
I know you probably don't want to get two guns, so get the revolver first, but rapid-firing 15 shots from a semi-auto is something you just can't do with a dual-action revolver. It's cathartic.
And just an FYI for others, Memphis, Nashville, Tampa, Oklahoma City, Mobile (AL), Tucson, Colorado Springs, Denver, Albequerque, Wichita, Minneapolis, Charlotte (NC), and about 25 other populous cities all had a higher violent crime rate (Murders, Manslaughters, and non-negligent homicides) than New York City in 2008. Detroit's was 8 times worse. The Big Apple ain't all that bad. Sure, don't walk around Liberty Ave in Jamaica, Queens at 1 AM. But that doesn't mean New York is bad.
And no, personal embarassment is not punishment enough for the illegal discharge of a firearm in a public nightclub. And I don't think Antonio Pierce (Plaxico's linebacker buddy) was too embarassed when he drove the gun to New Jersey and hid it. If anyone fires a gun (even into their own leg - the idiot) in a public place, they've committed a crime (probably a felony) pretty much anywhere in the country. Carrying does not make firing OK. As a gun-owner, I'm obviously all for people being free to exercise their second amendment right to KABA, but it's morons like Mr. Burress who bring the ire of gun-hating liberals down on law-abiding people who practice safe and responsible gun ownership. [OK, off my soapbox now]