Midea reliable?
According to Amazon reviews, it is.
https://www.amazon.com/Midea-Inverter-Conditioner-Flexibility-Installation/dp/B08677DCKN/
Same for LG.
Get this AC and put it in your window.
Runs on 110 plug, drips outside (if at all), U-shape allows you to close window and keep things quiet.
You want either the Haier Serenity series or it's GE equivalent, Premium Quite Air Conditioner AHD08LZ or GE Profile PHC08LY . All 3 are essentially the same and 43 DB . In 6K or 8K BTU but will cost you significantly more unless you can find a used one . $300-400
Then there are the novel U shaped ones from Midea and SoleusAir (Gree)
https://www.amazon.com/dp/B085P27VNF/ref=twister_B085P2519J?_encoding=UTF8&psc=1
https://www.amazon.com/dp/B08677DCKN/ref=twister_B086VZGZDM?_encoding=UTF8&psc=1