Best rom for me

I've had trouble in the past with rooting and whatnot, and while I have everything fixed up I really want to utilize the things I've done to my phone. Would someone be able to not only suggest an excellent rom but also where to find it? Also, since my phone is rooted, do roms upgrade the os to gingerbread or is there something else I need to do?