Aeropress makes an ok’ish cup of coffee, but hugely overrated IMO. At work I use a press (Go Outdoors) and, for a cup of coffee, it works a treat.
I did have a handpresso, but left it someplace abroad, it did need pods bought off the internet, but for espresso it worked up about 16 bar and gave a nice strong hit with really thick crema. That may or may not be what you want, so think about whether it’s coffee or espresso you want.
Most stove top espresso makers are ok I believe and a pretty decent cup of something stronger than coffee but not as strong as espresso (I think 3-4 bar is the top pressure)
Coffee wise, I get mines from a local coffee roaster (use them or loose them) and the best they’ve done so far was a guest coffee – Ipanema Estate, Brazilian, which was quite sweet and chocolatey. Just now I’m on Java which is probably a Highland Park of coffee – I think everybody would like it, so maybe a good place to start. Bruzzi is another Brazilian estate, not quite as sweet as Ipanema but very nice.
I used to use a bladed grinder, but picked up a cheap burr grinder in the sales , expecting it to be relegated to the same dark corner as the aeropress – nope, well worth the space it takes up in the kitchen, makes a much more consistent cup.