I posted this on a stargate forum, this is what I'd like, a ship series finally
Stargate: Tempest
The USAF prospero, a new combination of technologies goa uld, ancient, asgard and..... FURLING is tested, and it's drive system, going terribly wrong, strands the crew in extradimensional space, ninth chevron time, and hangin' out with ancients time
also we can play with time travel, alternaternate timelines, all that fun stuff that sci fi people freakin' love in an extradimensional tempest, all the while being hunted by what initially seem to be dumb creaturse, but are later discovered to be incredibly intelligent sentient ascended beings
we get to leave the ship, say every (insert number of hours that has astronomical significance) and do missions and pick up supplies, but get ripped back to the ship, via the stargate and ninth chevron we can get back, but we can't explore new without the x number of hours pulldown, we could develop <fairly early in the season to cut down on the annoyance factor> a device that makes it so only part of the ship is vulnerable to the pulldown, and they want to explore anyhow, and have to for supplies and to try to find a way to get out of extradimensional space
it's more complicated than tthat, and there are plotholes, but, I dunno, I think it has potential