That 325i looks very average. I'd recommend one with xenons, sport package, and of course a manual transmission.

As for problems, lots of info here: BMW E46 - BimmerWiki

Generally speaking, its things like window regulators, cooling system, and wiring connections for the rear taillights.