Towards Near-Optimal And Adaptive Algorithms In Minimax Optimization