I'll answer for Phi Sigma Pi (National Honor Fraternity).
Reputation -- I'm not sure that we really have a reputation on my campus, past people who are friends with those of us in it. We're a small chapter, and we're not that well known on campus.
Social orgs in special interest letters -- I'm not really sure what you mean by this...but we are a primarily social org. I would say that's why most brothers join my chapter. We do other stuff, like service and fundraising, but a lot of it is the brotherhood.
Extremely anti social greek -- Yes and no. I'm also a social greek, and was before I joined PSP, so people could hardly say to my face that they hate all social greeks. I highly doubt that anyone in the chapter is that narrow-minded, anyway. Some of them do very much dislike the "greek" way of doing things, though, and adamently swear up and down that they don't want our chapter to become any more "greek". Then those same people were all very enthusiastic when we started participating in Homecoming things last year...
Just another club -- Nope. We have brotherhood and chapters across the country.
NPHC wannabes -- nope. We're pretty much off on our own, doing our own thing. Most of us would probably look like idiots if we tried to do a step routine anyway.