Orbital habitats with rotational gravity.

fusion maybe, but in scifi, it often requires an alien race making first contact, we wont even get to things like anti-matter tech without that intervention. SG1 is more in our time frame, but with aliens already possessing advanced tech

Exoskeletons like Ripley's in Alien. We've got smaller ones, but I want to pilot a walking fork lift.

Pipe dream - battlemechs aka mechwarrior (not pacific rim). Very impractical but I want one anyway. Yes, I saw the robot fighting league by Megabots. I have their poster.

I would guess that we'll most-likely have AGI in 100 years. That's pretty futuristic and impactful.

I'd really like to at least see humanity fully switch to clean energy in my lifetime but I'm losing hope.

I should already be able to take a self-driving flying taxi to work. I should already be able to vacation on the moon. We shouldn't be burning stuff to power all our modern tech.

I grew up on 80s/90s scifi. I hope humanity can get it's shit together and that the current anti-intellectualism phase we're in is just part of a larger cycle.

Sex robots!

Robocop Bell Riots suppression?

I think genetic engineering is the most high-potential tech right now. They're already using it to cure sickle cell, and my (total non-expert, probably way too hopeful) pipe dream is that we could basically treat it like we can open a terminal on the body some day and change whatever we want.

Edit: I just want to point out that I'm imagining curing cancer, reversing aging, etc. Not like, additional orifices or anything.

The Oscilation Overthruster.