CC65 has example software and NES .ROM file outputs to test, if you want to learn it.
It can only compileto NROM, which means that the limits are games similar to Donkey Kong. I think that the RAM table limit is 4KiB. I'd love to see something in the future that supports CNROM or MMC1, but I'm not holding me breath. Choke, cough.