I was dragged kicking and screaming into the Rotax camp, but now, coming up on 1700 hours of: changing the oil every 50 to 75 hrs (using less then a qt in between, and NAPA car filters) plugs every 500 hours or so (NAPA or Car Quest again), check the gear box at about 1,000 hrs (way over the recommended but still showed almost no wear, same with the carbs), I am a believer! Zero problems or issues, and at most, if I had to round off (and up) all at 4 gph on mogas, E 10 even.
Rotax is ridiculously conservative with their called out maintenance schedules, on average I double them (not on purpose, but looking backwards), and still have zero issues

I have heard rumors of many going over 4K hours with no major problems. Like any engine flying often seems to be easier on them then infrequently.
The sound they make is for sure different then a traditional aircraft engine, just like a Harley sounds different then a Goldwing bike. The prop and the way it is setup can have a major impact on that, but what the heck, with the modern ANR headsets (and SAT entertainment radio) who cares? The PERCEIVED noise from the ground is much less, and probably the best thing to happen in a while as per flyer/non flyer public relations. They can't complain if they don't even hear you! Hang out long and often enough with the Rotax crowd, and when a "regular" airplane flies by, you will be amazed at how long you hear it coming and going, the time span hearing it is much greater, making the tonal difference pretty much inconsequential.
I was on a crane job the other day, and a neighbor was there also. As another old timer up here on the mountain, (he was born and raised up here, and I know his dad, unlike the other newbies) when I climb out when N. bound, clawing for altitude to clear the 8 K pass) I often overfly his place at 500' to 750' or so. Full or nearly so power, and often before the sun comes up. In a pause in the work I asked him if he ever minded..... he said no he didn't mind, and in fact had never even noticed! Point being, that low overall sound level has major operational advantages, especially for those of us who fly out of rural residential type home strips.
It's also the lightest thing out there, besides being the most reliable, for LSA types. Other contenders have yet to gain a major foothold, as in total fleet hours, nothing is even close. Anyone want to venture the highest time UL engine out there? And how many of them? If my 912S took a crap tomorrow, I'd buy another in a heartbeat.