Here are some of my favorite, and relevant sites:

Akimans Blog

Aristata Publishing

Bioware

ConceptArt

Jules-Joseph Lefebvre

Studio Escalier