Definitely quieter, though unless you have the fitting bang on adjustment wise (sometimes scuppered by aging rubber seals on the windscreen surround) you will get wind noise over and above that of the soft roof.
Rear visibility is marginally improved, just by an inch or so either side - enough to make a difference on the motorway though.
Looks are subjective - I for one think the coupe-ish look of the hard tops is fantasitc.
Cost is an issue - finding one in good condition, in the right colour, with all trim present will set you back around a grand. Storage can be a pain, but you can either wall mount, ceiling mount or buy a rollable stand. Decent cover advised to protect your investment.
I bought one for the same reason as you, as I used my E85 pretty much as a daily (unless the number of passengers required dictated I couldn't) but fell out of love with the car before I really got a chance to use the hard top much. It would have really bugged me though, not being able to put the roof down when the odd sunny, crisp winter day cropped up.
Hindsight is wonderful isn't it - my E89 ticks many boxes and solves a handful of issues when compared to a hard-top equipped E85, rearward visibility being very high on that last!
For what it's worth from a previous hard top owner - don't buy one.