Thank you Scotty for your content and helpful advice. I have a two fold question about this issue 

I test drove an 09 MDX that has the 3.7L J37A1 V6 engine. Everything was fine at first but the check oil level light came on while I was driving. I pulled over and checked the level- it was a bit high but it may not have been sitting level. No noise from the engine when the light came on, no overheating, and doesn't leak any oil etc.

I researched and read the Acura TSB 09-012 on issues with the oil pressure sensor. The company selling the car bought a new sensor from the local Acura dealership but the light is still on. 

I have an option to buy it for about half the original price and I've already bought the full suite of  Helm/Acura FSMs for the 07-09 MDXs and been studying them so I can perform testing for shorts/sensor/tolerance checks of the oil pump. Maybe the wear just hadn't affected the cams yet but I've had a number of 86-89 Integras and 80s Civic/CRXs and with D and B series engines and a lot more miles on them and never had an oil pump fail. 

My questions:

1) Would an Acura/Honda oil pump fail without leaking /any noise?

2) the FSM shows the MDX J37A1 engine/ transmission is removed from below, can it be removed with a cherry picker from the top like the Integra's/Civics from the 80s? I don't have a car lift/rack and the engine is pretty tall. 

3) Is there an affordable solution ( maybe a low/mid rise lift?) for a guy that does his own vehicle work at home? I have a standard home garage space in a rented house and installing a post lift isn't possible.

Thanks for your help in advance!