What's the difference between electric condensors (super cardroid) to hyper cardroids or your run of the mill shot gun (AT897). Is it true that super cadroids are uni directional? is there an advantage to that?

I'm a little confused with your post. Condenser mics aren't necessarily cardiod, they can be omni, or hyper cardiod. Or "super cardiod" which is the same as hyper cardiod.
The 897 isn't a "run of the mill" shotgun, it's a shorter shotgun designed to work better indoors than most shotguns, which means it also suffers a bit in larger spaces where you'd use a more "run of the mill" shotgun.

Anything that is cardiod is unidirectional; by the mere definition of cardiod, it's one-direction.
Cardiod means "heart-shaped." Picture a drawing of a heart. Where the two curves intersect, this is where the mic pickup pattern is most sensitive. Anything behind that curve is rejected in varying degrees, depending on the particular mic model.

so whats the difference between a super and a hypercardroid or is it very close to being similiar?

Without knowing who's using the nomenclature, it sounds like advertising spin. If mic A is supercardiod and mic B is hypercardiod, you need to compare the charts. Then you'll see.

so whats the difference between a super and a hypercardroid or is it very close to being similiar?

Like I mentioned initially, and as Doug Boze points out, they are essentially the same thing. Marketing terms more than anything. Overall, look at the printed pickup pattern for the mic. You can immediately see what it is. Super, Hyper, Ultra....all words used to describe a very tight cardioid mic pattern.