Eire can not afford the union and the Northern Irish do not want it, so what Sinn Fein want is not really relevant.
Scotland can (or at least could before oil pulnged) potentially afford to go independent, though they would still need handouts from the EU to survive in the state they are currently in, so the situations are not comparable.