"Lost City" (Part 2) is the best episode for Prometheus. As is "Prometheus", "Grace", and that other one where Prometheus is stuck on the military planet. As I said before, I'll eventually have composites of every ship that has reasonable material around it. I might as well put up my latest list of USABLE canon ships known at the end of Season 7. THis is off memory (I'm at school)
Tauri X/F-302
X/BC-303 Prometheus)
Prometheus escape pods
AG3 Harsesis Defense guns (not as powerful, of course)
Cloned Goa'Uld ship ("Night Walkers")
Goa'Uld Ha'tak Mothership (standard)
Cheops (Apophis's ship)
Anubis supership
Apophis suership (never finished, destroyed by SG-1 in "Upgrades)
Transport/Cargo
Death Glider
Al'Kesh
Troop transport (oversized Al'Kesh)
escape pod (cargo ship)
Anubis escape pod
Needle Threader
Pyramid Ship (Raa/Heur-Ur)
Asgard O'Neill
Baliskner (the class isnt mentioned)
Stronger version Baliskner*
Science Vessel (Loki's)
-there's also a lot of ships buzzing around the O'Neill in "Small Victories"
Serrakin Warrick's ship
Plane thingy (it's in "Space Race")
Attack drones
Prison ship
Ardenans Colony ship
Replicators attack ship (attacks Apophis's Cheops in "Enemies"
scout ship ("Unnatural Selection")
Baliskner (and presumably any other Asgard ship)
-and I've heard they have a lot of good stuff in season 8
Unknown Attack ship ("Grace")
Marty's Race Large vessel ("Wormhole X-Treme!")
Escape ship
TobinMines
There's plenty more. And remember this is USABLE ships. Stuff like the X-301 isnt included in this list. It will be in my excel sheet.
* In the episode where Thor is captured, the Freyr and the other Asgard arrive in vessels that he says are "much stronger than the Baliskner" This suggests a Fenris - Leviathan relationship between the Baliskner and these other vessels. One model, two ships.