Anyone that plays set-savvy? I know what the visual effects of the Aegis set and Borg technology are, but I have little clue as to what M.A.C.O., Omega Force, and Honor Guard do.
Again, visual differences; I've read the stats on the Wiki, and only the Aegis and Borg sets have any screenshots, which matter little as they're the only two sets I ever see with the exception of someone with what I think is the Omega Force deflector.
I've never seen somebody with a complete M.A.C.O. set, but I've seen Honor Guard ones; they're essentially optimized for carrier ships like the Orion flight-deck cruiser payships or Vo'Quvs. The M.A.C.O. shield is apparently to die for if you drive an Escort, so I'll ask a friend who has a Prommie and let you know.
Is this really any different?
This is a stupid statement and you should be flogged for it. You have a crapload of single-player content here if you just grind out the episodes, easily about a week's worth of playtime. Tack on another two weeks of running the patrol missions, and endless more if you want to do the explorations and diplomatics. As Mefustae says, the episodes and to some extent the patrols are really the best approximation of playing through an actual Star Trek series you'll ever experience.
Even then, only a small number of the pay options offer tangible gameplay benefits. A vast majority are vanity items; one of the variety of uniforms from the five and half million variations Trek has gone through, different bridges to stand around and be social in, different ship bits to dress your ship up with (did we mention you can customize the look of character, ship, away team/bridge crew?). The pay alternate ships are essentially like premium stuff from World of Tanks, nice, but not actually that much better and outclassed by regular stuff of higher tier. You don't see them much.
In fact I dare say the only ultra-useful paystuff available is the Multivector version of the Prommie, and you don't see those much. (One incredibly powerful gunship into three slightly less incredibly powerful gunships.) Klink types do seem to like their pay Kar'Fi carriers but I don't see them in action to tell if they're better than a Vo'Quv.