Franco's apartment is spacious and pretty much in amongst all of the hustle and bustle of Rome. Close enough to walk down to the Colosseum and Forum - with plenty of lovely restaurants and bars along the way.
All other sights are a quick bus/metro ride away with a bus nearly at front door and train 5 mins away - public transport is easy in Rome.
The apartment is on street level and there can be traffic noise and some noise from restaurants nearby - we were tired enough each day that this was not a problem for us.
If returning to Rome we would certainly be checking back in at Franco's place
We stayed 6 nights and had a ball.