Difficult decision...for me there is no fun in photography is you have to carry around a bulky item.
So, forget foreground/background separation. It is not needed to do good photographs. It is needed to do some kind of good photographs.
Anyway, take a look at some mirrorless, which should be slightly smaller, however you have always to consider a couple of lenses, which might be "bulky".
Or: consider complementing a P&S with a dSLR (usually is the reverse). E.g., when you want to shoot portraits you do the effort of bringing around a bulky item, if not, no need.
Or find an old used Olympus dSLR (E 410, E 420...) - smaller than any other dSLR, the right lens, and that's all.
This tool might help you in understanding sizes before checking in a shop:
Compare camera dimensions side by side