Have you checked out the Small Cool Contest going on at Apartment Therapy? It's an annual feature where real apartments compete in 5 categories of small apartments. Voting is allowed only for 48 hours after the apartment link is posted. I've been voting for my fave ones for the past three years and really enjoy looking at "real" homes. Somehow this year, there hasn't been any stand out apartment so far. Lots are really very ordinary apartments, that should have done a bit of work before taking the shots, simple things like waiting for better light etc. New apartments are listed everyday, so hoping something more artistic, vibrant and put-together comes up.
Edited to add:
Yay, I've found one that I really like. Michael's apt in Traverse City, Michigan.
Also, check out Matt and Jac's apt in Winnipeg, Canada.
And, Lasse's apt in Herning, Denmark.