It sounds like you want something a little more arcadey than realistic.

If I were you (and multiplayer sounded like a good time) I would legit consider something in the Battlefield series.

Arma 3 has a bunch of land sea and air vehicles and a lively modding community creating missions for you to play solo or multiplayer.