During QE the central bank can also acquire other assets that are riskier than bonds and take risk off other people's balance sheet, again hoping that money will be used to stimulate the real economy.
At 0% it pretty much stops working. Up to 0% some bond holders are still holding on because they are betting on that being the better investment. The other problem is how do you exit QE. We're going to find out how that works over the next few years...
But at a certain point, interest rates are low enough that lending is limited by the lack of creditworthy borrowers or by bank capital requirements, and so further reductions will have very limited impact.
You are correct - at a certain point there are no investments with a positive real rate of return. At this point all further resources should be devoted to consumption regardless of time preferences (interest rates). If consumption desires are also completely satisfied, then you are in a post-scarcity economy.
Almost by definition [1], when you reach that point, you are NOT in a recession.
What's the relevance?
[1] The technical definition of a recession is 2 quarters of negative growth, but for theoretical purposes it generally means a period when real resources are not fully utilized.
At a certain point there are no investments with a positive real rate of return. If consumption desires are also completely satisfied, then you are in a post-scarcity economy. Almost by definition [1], when you reach that point, you are NOT in a recession.
You don't have to be in a post-scarcity economy to have no lending opportunities at the margin. It is also very possible to have no additional lending opportunities, at any positive interest rate during a recession. This is especially so with the way that capital requirements work. If a bank doesn't have adequate capital ratios, they cannot lend, no matter what the rates.