I grow well in a north facing flat, so the honest version of what that limits and what it does not.
What a north window gives you is soft light with no direct sun, all day. Right up against the glass that is genuinely bright indirect and a lot of things do well there. A metre back it is medium. Three metres back it is low.
So the useful move in a darker flat is not different plants first, it is different positions. Everything that wants light goes on the sill or immediately beside it. The middle of the room gets the tolerant ones or nothing.
What actually tolerates low light and still grows: pothos, snake plant, ZZ, aspidistra, some philodendron, ferns if the humidity suits them. Slowly, but genuinely.
What will always disappoint in low light, whatever the label says: fiddle leaf fig, most variegated anything, succulents and cacti, calathea in a dry room, anything with strong colour. Variegation in particular needs more light than the plain version of the same plant, because there is less green surface doing the work.
A grow light is a completely reasonable answer and it costs less than replacing plants twice. A single decent bulb in an ordinary lamp, on a timer for ten hours, turns a dead corner into a usable one - and the difference is visible within weeks.