I am planning to get white filler in a cavity. How do they look in terms of aesthetics?

Pretty good. In general they look great. Clearly if your teeth change in color with age, the filling may be more noticeable but it is still a better cosmetic option compared to amalgam fillings.