Others have made great points and I can't speak to AWD vs RWD or even the driving experience as I'm a week or two from delivery, but I did previously have a Ferrari 458.
My experience for the car and with the dealer was all very positive and the car itself was a masterpiece but there was something about brand perception that was sort of strange. My garage in Manhattan that I had been parking at forever suddenly started calling me "sir" when I got the Ferrari. There's some sort of a probably self imagined aristocratic grey poupon-esq old conservative opulence schema that coming from the world of unpretentious and effusively obsessive Lotus fandom didn't quite sit well with me. Again, self created I'm sure. But I will say, there does seem to be a bit of a difference in candor between archetypical Lamborghini and Ferrari tropes. So far, no one has bat an eye at the fact that I purchased a snow tire and wheel package for my Huracan and will use it year round. But when I did that for the 458, while folks thought it was cool, boy was it a talking point. I absolutely met plenty of nice Ferrari people and I do love the cars, but there is just something about the Lamborghini flare for the present and not worrying about the pollen count much less the odometer when taking my car out of the garage that resonates more with me. Again, this is my bias and probably self imagined.
Other Ferrari things like the damn sticky button issue (which I would imagine is not a thing on the Roma) were a little tiresome, as I was always using my knuckle to touch buttons so as not to get the oil on my hands to further expedite the degradation. Thats to say I'm VERY happy to have the VW parts bin for the stupid little things that just need to work.
One final thought on the Roma as I went to a premiere event on Long Island and got to play with one a little. Looks are subjective, I'm mentally 5 and will always prefer a mid engine fire breathing Lambo aesthetic, but the interior of the Roma is laden with "screen" based haptic not real buttons that drive me INSANE. The interface is also very laggy on the Ferrari. While there are no great fans of the EVO infotainment system I still would consider it a step up based on my experiences.
For my $0.02 were I after a Ferrari I think I'd go for a 488 (F8 prices are just stupid at the moment) or a 458 if something older is within the purview (or certainly an F12 or 812 superfast).
Finally, I have to admit I thought a lot about the famous story of Enzo telling Ferruccio that he was just some tractor maker, the son of grape farmers, and what business did he have in telling Ferrari how to improve his cars...Lamborghini is what happens when you sardonically chide a talented dreamer and I do honestly think that spirit is still imbued within their ethos, culture, and design. When I told the folks at Lamborghini when I went to visit that part of the reason I went with Rosso Mars/Terre is because I thought Ferruccio would appreciate that my color combo would tick off Enzo and the Ferrari ilk for creating a Lamborghini in the likeness of their stereotypical hue, my guide at the factory smiled and she said "Oh I think he would have liked that". Needless to say, my tortuous life path has led me to Huracan against conventional wisdom or common sense, and it feels great.