Hi Robert
I'm going to have to answer your many questions piecemeal today - if that's OK with you

.
First of all - solenoid valves with a more convenient means of accessing the manual override facility:
The standard Bosch-Rexroth solenoid DCV comes with a concealed manual override (code: N9). The common alternatives shown in the datasheets are: the rubberised thumb button (code: N) or no override at all (code: {leave blank}).
What they don’t show on the datasheet are:
N7: as N9 but with a locking function (I think it’s a push and twist with a screw driver)
N2: Small mushroom button (palm button) – not lockable
N4: as N2 but lockable via a small spring clip which can be pulled over the top of the button
N6: as N2 but a bigger button (palm button for big hands)
N5: as N6 but lockable by a push-and-twist scheme
If you are going to use a lockable manual override then you must use a DC solenoid (even if you use an AC supply with a rectifier built into the plug). If you energise an AC coil with the opposite solenoid locked in (via its manual override) then the energised solenoid will continue to draw its in-rush current and will burn out after a few minutes. DC solenoids don’t have this problem.
Sun Hydraulics offer some interesting solenoid tube end caps that incorporate a twist to operate function (far more comfortable and convenient than pushing a probe into the normal concealed override). Sun also have a version which locks into place when you twist it, and an ingenious one which is momentary when you twist it one way and locks in place when you twist it the other. (See part numbers: 991-225, 991-226 and 991-227.)
Wandfluh offer some very convenient manual actuators on their solenoids as well – most of these can be retrofitted to the standard solenoid.
Walvoil do offer lots of their valves with solenoids on one end and the lever on the other - but the price/delivery may not be right for you, especially if you don't need any proportionality.
I'll get back to you later with some other answers.
DOL