Solution 1:

After following to the letter the How to install and configure Wine? guide including the part about making sure the WINEARCH is wine32 and using Windows XP as the default OS you need to install the following components using winetricks to have it exactly like my case:

d3dx10
d3dx9_26
d3dx9_28
d3dx9_31
d3dx9_35
d3dx9_36
d3dx9_39
d3dx9_42
d3dx9_43
d3dx9
directx9
dotnet20sp1
dotnet20
dotnet30sp1
dotnet35
dotnet40
gfw
mfc40
mfc42
msxml3
msxml4
msxml6
physx
quartz
vb6run
vcrun2003
vcrun2005
vcrun2008
vcrun2010
vcrun6sp6
vcrun6
wmp10
wsh56vb
wsh57
xact_jun2010
xact
xinput
xna40

After making sure all of this components are installed (Not all are needed for this game, but this are the ones I had installed already when I tested the game), you can install the game. In my case I used cdemu to install the 2 DVDs. After installing both run the Patch 1.0.7.0 then follow the instructions mentioned below in the comments in the WineHQ Comment Section to patch the Xlive DLL in order to avoid the Games for Windows - Live.

Note that the patch 1.0.7.0 actually disables the need for this by uninstalling the social part but you still have to put the DLL mentioned below in order for the game to actually start.

Here are some screenshots of the game in action:

enter image description here

enter image description here

enter image description here

And here is a video: https://www.youtube.com/watch?v=q0Juf4LC--g&feature=youtu.be

UPDATE: As mentioned by the youtube comments of Jean-Michel Beriault, the game works great on 64-bit, you still need to install dotnet30 and vcrun2005 but after that it should work. Thank Jean for the testing.