Why are niche hobbies and interests a turn off to many women?

They aren't.

Also why is this thread about dating from 2010 on the front page of Hacker News?

They aren't, so this topic is off to a bad start. Nice try in pigeon-holing an entire sex.