Loved MD Alien 3 and often return to it just for old times sake.
SNES Alien 3 i actually bought a 2nd hand SNES for (well that and Choplifter III and Mr Do!) as Nintendo in-house stuff never really appealed to me and i find it compliments the MD version superbly, being far more of an atmospheric exp.
Alien 3 and Konami's Aliens i've only ever played via MAME, both worthy enough games, but i no longer have a PC and i gave away the soft-modded Xbox i had with Aliens on, to a friend.
Never tried Aliens Comic Book adventure, whilst i was a PC owner, think poor reviews might of killed any/all interest for me at the time.