Brownfield Cleanup Enhancement Act - Amends the Comprehensive Environmental Response, Compensation, and Liability Act of 1980 to authorize appropriations for FY2010 and each fiscal year thereafter for: (1) the brownfield site characterization and assessment grant program and for grants and loans for brownfield remediation; and (2) state and Indian tribe brownfield sites response programs.