There is an ICS ROM but it never left beta. Some features, e.g. the camera, do not work with ICS. The most stable ROMs are on gingerbread. For details about the Streak, read the forums and the wiki.
As to whether it's a good deal or not, it depends on what you intend using it for.