At risk of repeating myself, the X-pipe is fitted as standard, so if you replace it with one without a resonator it will sound like it does now, but a bit louder and with a few more crackles and pops.
The H pipe will sound like an American V8, more of a throbbing dirtier sound, quite unlike the original exhaust.
Neither of them will sound like a Ferrari, the firing order is different. If you imagine a Ferrari V8, with its flat plane crankshaft sounds like two four cylinder engines, in stereo, firing consistently slightly out of time. The cross plane crankshaft in the Maserati version of the F138 means that the timing of the cylinders is a-symmetrical, giving the off beat sound that most people associate with American V8s.