The 147 is a great car but it will be strange coming from an MX-5 because all the 147's are front-wheel drive. The 147 has super light steering which is very precise but I have to say does lack some feel, it also has the turning circle of a moon. Out of the city it's great to drive and a healthy car will lap up the miles and make you grin all the way. The petrols sound bril and should make driving to Italy a bit special. The diesels feel a little heavier at the nose but there's a ton of grunt to power out of the corners. Healthy suspension makes a big difference here. The driving position is excellent with very supportive seats but they need to be because the ride is a tad firm... I'm lying, it's very firm.
The interior is a nice place to be especially if you get a car with leather seats, Lusso trims and above tend to have leather. Also Alfa didn't use hysterically terrible plastics for the dash etc which is nice. The interior is quite spacious in the front but the back is cramped and there's really only space for 2, especially in the 3-door cars.
Now I hate to say it but you might not acheive Mazda reliablility levels with an Alfa, though honestly my 147 has only suffered minor niggles, battery/EGR for example. Keeping up to date with maintenance will help a great deal here.
The Twin Spark engines are designed to use some oil so it's important to check and top up the level regularly. Aside from that it's the cambelts you need to check, replacement should be every 36k or 3 years whichever is sooner. The cam variator tends to need replacing every other timing belt change, from what I've read they sound like diesels when the variator is worn. I've driven the 2.0 a little it laps up the revs even if it lacks a bit of umph (that might just be me being used to the diesel) but the noise is great, even better if it's the V6. They average not much more than 30mpg though because you develop a heavy right foot if you know what I mean.
Diesels on the other hand don't normally use oil but need cambelt & waterpump replacements every 60k or 4 years whichever is sooner, £350 is about the going rate for this work. The usual EGR malodies are common and can be avoided by cleaning them every few thousand miles. I've had my 147 JTD for over 2 years now and remapped it has bundles of torque, power and even decent economy although it does sound like a taxi when it's cold. Get one with the Q2 limited-slip diff for the best results.
Servicing is fair, I pay around £150-£200 all in for a yearly service depending on what filters I choose, Engine Oil, Motor Oil and Car Engine Oils from the largest UK independent online supplier of Performance Oils
will see you right for service kits. Rust shouldn't be a problem but do check the floorpans from underneath and the sills, which can be damaged and begin to rust due to using an incorrect jacking point. Check for any electrical gremlins and make sure everything works properly, but generally the 147 is reliable here. See the guide here for more bits to check for: Alfa Romeo 147 Buyer's Guide
There's some bits I'm bound to have missed but you get the general idea, sorry I can't be more specific with the petrols, I need more practice. People call me a philistine for choosing a diesel but they're still good fun.
Best of luck with your search!
147 Sport Q2: Autolusso Remap + Swirl Flap & EGR Delete, Mocal Oil Cooler Kit, JTD Performance FMIC Kit + High Flow Elbow, Wizard Downpipe, PF Pads + 5.1 Fluid, Autolusso Braided Brake Lines, MTech Short-Shifter, Autolusso Silicone Turbo-to-MAF Hose, Refurbed Q2's + Some to add later.