My first impression of the Sink was that it was a sink(literally) and that we would get shrunk down and make it into player housing. Well, I guess that theory of mine just got violently murdered. Can anyone tell me what exactly is the Sink? Is it just a fancy house with a fancy name?

It's exacly what you described it as, a fancy house with a fancy name