Honestly, if you have awareness of what came just before and after it, Black Knight was an extremely important, influential, and successful game. For that reason it gets my vote ( best for its time ).
My personal favourite is probably STTNG, but what few games I've had on ACDC were pretty awesome, and I've never played SM.