There are several folks working on 2.3 ROM's - I'd check the ROM's and Hacks section for your phone to see who is working on it.
Usually the first gen ROM's have issues, like camera's and such not working but they eventually get it all worked out. And yes you have to be rooted.