In my opinion MPG gain from lightweight rims might be small compared with purchase price however if rims do not get damaged there is only minimal loss in value in time. When you get rid of your car you can put your old rims on and sell lightweight ones for roughly the same price you bought them (if you're lucky).
Of course some investments are not there for making profit, some are just to make you feel better and that's not a bad thing either