I think the old Sovereign bridges and the new ones do look good, and pretty close to what the Enterprise E looked like in the movies. The only problem is it is too damn big. What it looks like for the Sovereign, Defiant and Galaxy classes especially was they were designed very close to the source material, in appearance and scale, but then scaled way up, making them look bad. For the Galaxy class bridge, obviously the rear wall consoles are ridiculous, and the tactical arch thing doesn't look right either as it has to cover a large area of space but remain only waist height. As for the Sovereign class bridge, it has the right bridge stations, in kind of the right places and the right number of steps, but because of the insanely huge size nothing looks right.