You're right that just about every lift has had it's share of mixed results, some more than others.
The top mount spacer lifts push the CV joints closer to their limits causing vibration, etc, so the smaller you go the less likely you'll have issues.
The most common complaint with lift coils like STU's is topping out over drop offs like pot holes, and some don't like the firmer ride.
Getting the right tire and rim combo will give you the most bang for the buck for looks and performance with the least amount of side effects, and if you do have problems it's less work to swap a set of tires out than remove a lift that's causing problems. If you want to start wheeling on light trails (yes, you can wheel a FWD

), tires will do more good than a lift, and a set of skid plates is a good option.
I'd say start with the tires first and see how that goes, then you can decide if you really need/want a lift, and whether the extra cost, work, risk, etc. will be worth it.