After they quit making them, it became so desirable, that people were paying up to three times the original sticker price. For used ones!
Limited production doesn't automatically mean desirable. I had a very rare yet unpopular car, a Volvo C30... and trust me it was no fun owning something that nobody can service or get parts for. Thankfully the SC is based on the Tuscon which Hyundai's best seller, the engine and tranny are shared with other H/K vehicles so hopefully the SC is supported well for years to come and doesn't become a rare bird or orphan.