Brian,
Go with what you know/like/feel comfortable with.
The Rotax is a good engine but has it's own issues, i.e. carb sync, expensive rubber replacement every 5 yrs, expensive ignition modules etc. Some guys have these figured out and do good preventive maint. Some don't.
For what its worth you can equip a Lycoming or Conti with electronic ignition and fuel injection (flyefii.com) and have a lot of the same "benefits" of a Rotax. No mixture, uses automotive spark plugs etc etc. The system cost is similar to buying a couple mags plus gears spacers, spark plugs etc and a carb. Yes its a little more complex than mags but the engine will run smoother and start easier. Also there's no 500 hour mag overhaul requirement (not that many do it), The Rotax built in alternator is limited in capacity and expensive to upgrade. You can add an external alt but be prepared to pay heavy just for the mount.
Are the Lyc/Conti engines heavier than a Rotax? Yup. Easy to work on? yup. Lots of people out there with experience on these engines also.
As for fuel burn, I personally don't care if my KF has a 6 hour endurance because I can't sit for that long.