I'm dealing with the same thing! I took off failing plaster from an old brick wall. The wall runs parallel with the floor joist so I've got a huge gap between the floor and the wall. I've thought about spray foam but then I feel like it needs to be finished off with something a bit more...