Scared? Nahhh...no reason for that. These are probably the best cars on the market...and I would encourage you to add 07 and above to your search in the 6sp mt format.
The most common reason for footwell water is the vapor barrier wasn't reinstalled properly when a window regulator was replaced. Easy fix with a blow dryer and fresh butyl tape.
The pano is a secondary concern but the newer the better. I'm at 107k and mine hasn't been an issue in my 09, but I rarely open it...I just leave the cloth divider open because I like the open feeling.