No sci fi effect has ever given me the same sense of wonder that I got from the shot of the camera slowly travelling over the gigantic ship in the Season 1/2 intro.
Btw: @dang : Grant was the co-creator, alongside Doug Naylor, who is still kicking
In the case of "Red Dwarf", the genius was in having the ship be an ugly industrial environment in the vein of "Dark Star", "Alien", "Outland" etc. That allowed for sets to be built easily and cheaply. I think some of it was even filmed in a BBC canteen/cafeteria.
You see this with TNG v DS9. TNG would have one alien ship in an episode at best. It forces you to write story. Come DS9 and you can have 50 bajillion ships on screen so they write a story to make that happen. That isn't necessarily a bad thing, DS9 and B5 are good shows, but I miss the days when Captain Picard would mull over the implications of the prime directive with a cup of tea.
"We open on the corridor of a space ship. Space Odyssey this is not, no high tech serenity here. No, the is very much an ordinary, boring corridor. It could even have been a corridor in a TV studio..."