Arguably SG1 and SGA both had their own 'holodeck' adventure stories. From the top of my head I can think of at least three eps where they got trapped in some kind of VR/dreamscape (though that still doesn't come close to trek's mandatory three eps a season).