did you want to insulate the rest of the house from the tenant in the basement?
I used green glue (between floors) and its pretty good. It does a very good job at insulating noise such as talking, singing… I don’t even hear any babies crying and there are alot of little children nearby. You do hear vibrations and thumps like footsteps and children running.
I dont see what spray foam would do for you.