Even with the point and shoot you can get what they call add on lenses with some models. Usually requires an adapter that goes over the existing lens and then you add on another lens for special effects like macros, wide angle, telephoto etc.
The s5200 that you are looking at does have the option of thread on 55mm conversion lenses for macros/wides/tele etc., just not sure of the prices for any of these. Looks like a good all around camera though.