I totally agree. I used to use the 4k Dell in my signature which was the perfect size but since I had to relocate I no longer have space for a 27" screen. I would really like to get one of those 'old' apple cinema displays in 20" or 23" but non retina, non 4k and super dated... just look clean and are cheap to get on eBay.
Will they work with my rMBP and which adapter do I need? DVI to Thunderbolt? Does that even exist?
Don't dismiss a good quality third party external display - there are many great ones on the market. However if you do consider a 4K or 5K display in the future, you just need to pay attention to the native resolution of the display. If it's a 3840 x 2160 display (which isn't quite true 4K but some manufacturers obviously don't care about technicalities), OS X displays the picture on the screen by "pixel doubling," so the effective resolution ends up being 1920 x 1080 (you are still running at the display's native resolution, of course). If you run at another supported effective resolution, OS X can handle it but at a performance hit; since it's not just a simple case of doubling the amount of pixels displayed equally across the display.
Point being, consider what the effective resolution will be and whether that is OK to you given the screen size. If you run at a resolution that results in a performance hit, it's quite noticeable (and not good either).
To answer your question about using the Apple Cinema Display, you can
use a Mini DisplayPort to DVI adapter to connect a 20-inch or 23-inch Apple Cinema Display with a DVI connector to any Mac with a Thunderbolt or Mini DisplayPort output. For connecting a 30-inch Apple Cinema Display with a DVI connector to a Mac with a Thunderbolt or Mini DisplayPort output, you need to
use a Mini DisplayPort to Dual-Link DVI adapter instead. Apple's adapters are overpriced though - you may find cheaper third-party adapters elsewhere from reputable brands that can function to the same standard, but don't vouch me on that - I've never purchased any kind of Mini DisplayPort to DVI adapter as I don't have a display that can only do DVI.
I am not sure if you are aware but the 4K and 5K iMacs no longer support Target Display Mode (i.e. using the iMac as an external display). If you plan to use an iMac this way, please remember it won't work. I don't know if this will remain the case for the 2016 iMacs (if we get any updates before the end of the year) but I suspect it will be. Target Display Mode was dropped on the Retina 5K iMac when it was first released because of current limitations with the Thunderbolt specification.