Mafia 2 is a pretty fun game. It is a lot like Grand Theft Auto, only set in the 50s and probably with much less carjacking. The Logitech G13 works really well for the game since it is a third-person shooter. I made a Mafia 2 Logitech G13 profile that has worked well for the game. It is a basic FPS-style profile with a few extra keys added to the game specifically for climbing, holstering, crouching, and covering.
Below is an image of the keyboard layout for the profile.