I tend to spend the most time in the spice district or center park, but I'll be sure to check the other lots you've mentioned. I haven't played a creative sim for the longest time and don't think I've been inside the art gallery in San Myshuno.
Funny you should mention vampires and aliens. I turned the old salt house into a loft apartment, where I have a doctor and detective in residence. The story in my head goes....one or the other would get attacked by a vampire, they would team up and take them on together. I haven't decided yet whether they will 'cure' the vampires or eventually have one of them turn into a vampire for a bit more conflict. Problem is, the vampires aren't cooperating and now the aliens have beaten them to it. For some reason both my doctor and detective have already been abducted, and I don't know whether to work that into the story or pretend it never happened, haha. I've been waiting for a vampire visit for so long, my sims are near the top of their careers and are already engaged. I might just have to visit Vlad and give him a little push.
Your family of vampires and aliens sounds fun! I don't tend to play with kids in my game, but it would be interesting to see the results....looks like you got a pretty good mix in there!