I switched to a tiling window manager years ago and never looked back, but had the luxury of much larger high-resolution screens. Would be hard to imagine it working well at 640x480 pixels. Even overlapping windows weren't great on such small screens, most people just maximized whatever they were working on.

Fullscreening windows is typically a feature of tiling WMs, and tiling often makes it easier to adjust the ratios of the splits in small amounts. I think tiling works well at all resolutions.