No, light pollution puts paid to that. The sight of M31 in truly dark skies - with naked eyes - is truly awe-inspiring.

A semi decent amateur telescope (I recommend starting with a dobsonian) and a drive to an area with low light pollution (perhaps the harder requirement) will fill your eyes with the many wonders of the night sky, M31 (Andromeda) included :)