I don't know if Powershot SX is considered "Pro" series, so sorry if this isn't a place where these are discussed.
I called Canon and asked what the best non-SLR camera for macros was.
They told me that the Powershot SX1, SX10, or G10/11 would probably take the best macro shots - one person said the SX10 would take the best macros because its shots are slightly better quality than the SX1, but another person at Canon said the SX1 would take the best macros due to RAW and the CMOS sensor. I don't know how important RAW is to a macro shot, but here's the breakdown.
The SX1 has a CMOS sensor and can record in RAW, and has a "super macro mode". ~$500.
The SX10 has a CCD sensor and cannot record in RAW, but also has the "super macro mode". ~$400.
Both SX's above can have attached the Raynox DCR-250 macro filter with a lensmate adapter (sample macros).
I don't have $1000+ to shell out for an SLR camera + good macro lens, so I need to start off slightly smaller the SX's look pretty promising. Anyone have any input here?